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 key

• A unique key used as a second key in another table

• To ensure that data is secure

What is a foreign key?

• A single unique key

• A unique key used as a second key in another table

• To ensure that data is secure

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

• The relationships between tables

• A query

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