Topic 11: Databases

Question 1

Define a database

Answer 1

A large collection of data items and links between them, structured so that allows it can be accessed by many different applications programs.

Question 2

What is a large collection of data items and links between them, structured so that allows it can be accessed by many different applications programs?

Answer 2

A database.

Question 3

Name two advantages of a relational database approach over flat files (like spreadsheets).

Answer 3

1. Databases can be made more secure by using a hierarchy of passwords. This means some people (eg managers) have access to all the data, while others (eg receptionist) can only access some data.
2. Data is stored separately from the applications that use it. So the data can be updated without needing to change the software.

Question 4

What can be made more secure by using a hierarchy of passwords?

Answer 4

Databases.

Question 5

What is stored separately from the applications that use it?

Answer 5

Data.