Chapter 2, Problem 1RQ

Explanation of Solution

Data dictionary:

Data dictionary is referred as the components of Database Management System (DBMS) that store the data features and associations. It also refers the data about data.

• It offers the DBMS with features of self-describing.
• It resembles x-ray of company’s complete data set and it is vital component in data administration.
• There are two main types of data dictionaries. They are as follows:
  • Integrated data dictionary
  • Standalone data dictionary
• The functions of data dictionary in the database design are listed below:
  • The contents of data dictionary are used for verifying the components of database design such as entities, attributes and relationships that exists between them.
  • Database design is used by the designer to check for their homonyms and synonyms.
  • It also verifies the entities and attributes created can be able to support all the queries in required way along with report requirements.