Data Dictionary
A file which contains descriptions of and other information about the structure of the data held in a data base. Typically it contains items such as filed name, data type, field size, format, default value, entity, whether it is a primary key.
Contents of a Data Dictionary
:check: A data dictionary contains details such as:
:explode: Entities
:explode: Relationship between entities
:explode: Field names
:explode: Attributes such as:
:explode: data types
:explode: filed lengths
:explode: validation checks
:explode: input masks
:explode: field formats
:explode: default values
:explode: key fields
:explode: Description of attributes