8525 AQA GCSE Computer Science 3.7.1 Relational databases

What is a database?

• A type of data

• A structured collection of data.

• A field

• A record

Select the correct label for this description.

An attribute in one table that is a primary key in another table.

• Primary key

• Record

• Foreign key

• Field

What is a record?

• A collection of fields about the same person, item, or object in a database

• One field about the same person, item, or object in a database

What is the purpose of the primary key?

• To store all of the details of a record in a database.

• To uniquely identify a record in a database.

What is a relational database?

• A database with one table

• A database with two or more tables

• A collection of tables which can be linked together by means of primary and foreign keys.

All of the data in a database is stored in a

• Field

• Record

• Table

A flat file database is

• where data is stored in a single table

• where data is stored in multiple linked tables.

What is an advantage of storing data in a flat file database

• It it is easier to set up.

• The same data is included multiple times, which can lead to inconsistencies in the data.

Primary keys cannot be duplicated whereas foreign keys can be stored multiple times in the same table.

• True

• False

....... Is a collection of related data

• A field

• A record

• A table