MYP 2 Database Assesment

Which of the following is an advantage of a relational database over a flat file database?

• Easier to set up

• Reduces data redundancy

• Allows unlimited data storage

• Does not require a primary key

In database management, what does the term "normalisation" refer to?

• Backing up data

• Organising data to minimise redundancy

• Creating random keys for tables

• Linking tables without primary keys

Which data type is best suited to store a phone number in a database?

• Integer

• Text

• Boolean

• Date/Time

A foreign key must always reference a primary key in another table.

A flat file database is better suited for large-scale applications than a relational database.

In a relational database, each table must have at least one primary key.

__________ is the process of structuring a database to reduce duplication and ensure data integrity.

The __________ command is used in SQL to retrieve data from a database.

In a relational database, tables are linked using __________ keys.

An attribute in a database table represents a __________ in a relational database.