7. Database Systems

Question 1

What is a Flat File Database

Answer 1

A flat file database is a database where all the data is stored in a single table.

+ Easy and quick to create
+ Can be made in non specialist software

• lots of data duplication
• all users see all data saved in the table (security)

Question 2

What is a relational database?

Answer 2

Relational databases split data up into smaller tables that are linked together

• more complex to create and maintain
  + removes repetition of data

Question 3

What is a primary key and a foreign key?

Answer 3

A primary key is a unique identifier for a specific record.

A foreign key is any field in a table which is the primary key in another table.

Question 4

What is database views

Answer 4

A database views allows a number of tables and records to be restricted so only certain users can see certain sets of data.