A data dictionary is a table that contains all the elements to be present in the database once it is implemented.
The data dictionary should include:
- Entity name
- Attribute names (fields)
- Primary and Foreign keys
- Attribute type
- Attribute size (text only)
- Required
- Validation
The data dictionary is the design of how the database and will be set it up.