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
Keys	The primary and foreign keys for each table
Relationships	e.g. one-to-many
Indexes	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