1.3.2a Databases

The rows in a database are called fields and the columns are called records.

• True

• False

Which of the following is not an example of what could be stored in a database?

• Sales Transactions & Financials

• Revision Resources

• Customer/Staff Information

• Product Information

A database is a ​ (a)   of ​ (b)   or information which is held together in an ​ (c)   or logical way.

• collection
• data
• organised

Match the following keys:

• The link between two table

• Surrogate Key

• Unique identifier for each record

• Primary Key

• Primary key using existing table data

• Foreign Key

• Primary key created from scratch

• Composite Key

• Attribute that together are unique

• Natural Key

What is true about a primary key?

• Must be unique

• Must not change

• Must never be null (empty)

• Must be used as a foreign key in another table