Data dictionaries

Data dictionaries are created during the design phase to define the structure of a database.

Creating relational database management systems can be time consuming, and a data dictionary will act as an efficient reference point during implementation.

Data dictionaries contain the following metadata.

  • name of each entity
  • name of all attributes associated with each entity
  • type of data that will be held by each attribute
  • size of each attribute (taking account of the overall file size to be held in RAM or backing storage)
  • indication of attributes that will be used as primary or foreign keys during implementation
  • validation rules that are to be applied to attributes

At Higher level, you are expected to describe and exemplify a data dictionary with three or more entities.