Worksheets1. Flat File & Relational Databases
Total questions: 10
Worksheet time: 5mins
What is a flat file database?
Contains a single table
Two or more linked tables
Used to create formula's
What is a relational database?
Contains a single table
Two or more linked tables
Used to create formula's
Select one disadvantage of a relational database
Avoids data duplication
All records in other tables with a link will reflect any changes made
Easier and quicker to add data
Can be complex to build from scratch
What is a primary key?
A single unique identifier for a record
A unique key used as a second key in another table
To ensure that data is secure
What is a foreign key?
Checking if a related record exists before allowing it to be entered
A field in a table that forms a relationship link with a primary key in another table
To ensure that data is secure and only repeated when required
Max wants to store his collection of DVDs in a database.
Which type of database would you suggest he uses?
A flat file database
A relational database
Zac works in a library. He has been asked to set up a database that will store the book information, customer information, and borrowing details.
Which type of database would you suggest he uses?
A flat file database
A relational database
What is this?
A flat file database
A source file
A relational database
A query (searching data)
Looking at the Order Info table, which fields are foreign keys?
Order ID
Customer ID
Book ID
Order Date
Looking at the Order Info table, which fields are primary keys?
Order ID
Customer ID
Book ID
Order Date
