Databases

Front

What is the definition of a Primary Key?

Back

A field in a table that contains a unique identifier for each record in the table

Front

What is the definition of a Foreign Key?

Back

A field in a table that is used as a link to a field in another table.

Front

What is a flat-file database?

Back

A database consisting of one table only.

Front

How would you define a relational database?

Back

A database consisting of multiple tables, that are linked using keys.

Front

What type of field would be best to store the following text: "11-00-67"? Options: Number, Currency, Date, Text

Back

Text

Front

What does a Boolean field store?

Back

True or False

Front

What can a number field be used to store? Whole numbers only, All numeric values, Calculations, Formulas

Back

All numeric values

Front

Which Act of Parliament ensures the prior consent of users before storing personal information?

Back

Data Protection Act

Front

What is the definition of a database entity?

Back

It represents people, places, objects or things stored in tables in a database.

Front

What is the definition of an database attribute?

Back

An attribute is a characteristic of an entity and will become a field during implementation.