Topic 11 Database systems Flashcards

1
Q

Access rights

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Password

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Query

A

Searching the database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Import/export

A

Transferring data to and from another program

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Report

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

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

  • Expensive
  • Hard to set up
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Flat file database

A

Only have one table of data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Relational database

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly