4. Typical data dictionary

When putting together a data dictionary for a database project, the analyst considers what kind of information needs to be documented.

The table below shows some of them:


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 elements that have been allocated for storing data in that field e.g. Integer(11) or VarChar(50)

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


The primary and foreign keys for each table


e.g. one-to-many


Any field that has been indexed to improve search speed

Access rights or permissions for the database

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


Challenge see if you can find out one extra fact on this topic that we haven't already told you

Click on this link: designing a database






Copyright © www.teach-ict.com