Topic 11 Database systems

Question 1

Access rights

Answer 1

Restrictions in a user’s access to only those files needed in order to perform their job.

Question 2

Password

Answer 2

A series of characters which need to be typed in before access to certain ICT resources is allowed.

Question 3

Query

Answer 3

Searching the database

Question 4

Import/export

Answer 4

Transferring data to and from another program

Question 5

Report

Answer 5

The output from a database in which the results are presented in a way that is controlled by the user e.g. list of patients with operations the next day to organise theatre schedules

Question 6

+/- of relational database rather than flat file (3) (2)

Answer 6

+No data duplication
+Much easier to search for specific information
+Data may be combined more flexibly

• Expensive
• Hard to set up

Question 7

Flat file database

Answer 7

Only have one table of data

Question 8

Relational database

Answer 8

A large collection of data items stored in tables containing links between the tables so that the data can be accessed in many different ways and by a range of different programs