Data Dictionary

A data dictionary is a table that contains all the elements to be present in the database once it is implemented

• True

• False

Data about data is known as?

• Metadata

• Data

• Database

• SQL

An Entity is another word for?

• Row

• Table

• Column

• Field name

An Attribute is another name for?

• Table

• Row

• Field name

• Database

A Boolean data type contains only 2 values?

• True

• False

A text field can hold...

• Letters, numbers and symbols

• Only letters and symbols

• Only letters and numbers

• Only numbers and symbols

A text type should always have a maximum size assigned

• True

• False

A number type should always have a maximum size assigned

• True

• False

Which of these is NOT an advantage of relational databases?

• Data is stored in one table
• Details need to be entered once
• Duplication is avoided

Data _____ helps ensure that data is reasonable, sensible and within acceptable limits

• validation

• checks

• accuracy

• integrity