2. What is in a data dictionary?

Table name

The unique name of every table in the database

Field names

List of every field name in the database

Field data type

The data type allocated for a particular field, for example, text, date, boolean

Field length

The number of characters that have been allocated for storing data in that field

Default value of fields

i.e. what will automatically appear in the field of any new record

Field validation

Presence checks, lookup, range checks, picture check which are applied to a field

Keys

The primary and foreign keys for each table

Relationships

e.g. one-to-many

Indexes

Any field that has been indexed to improve searches

Access rights or permissions for the database

i.e. who can change / edit / modify / read only