1. Flat File & Relational Databases

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