Data Dictionary in DBMS

By Prof. Fazal Rehman Shamil
Last modified on March 3rd, 2022

Data Dictionary

A data dictionary contains metadata of the database.

What is the metadata of the database?

The data about the database is called metadata.

Example of Data Dictionary/Meta Data

In this example, students is the database, and the fee is the table. If we want to know about the data dictionary of the database, then we can see that Attribute T4Tutorials_RollNo  having a data type of integer with a maximum size of 22 and null value as a no.

Example of Data Dictionary Meta Data
Example of Data Dictionary Meta Data

Advantages of data dictionary Data Dictionary

The data dictionary contains different kinds of information about the database. Some of the information is mentioned below;

  • Names of database tables
  • owners of the table
  • User permissions  of the table
  • security constraints
  • Schemas of database tables
  • when database tables were created etc.
  • Information about keys
    • such as primary key attributes and foreign key attributes etc.
  • Information about the database views having visibility.
  • Physical information about the storage of the tables

How to view data Dictionary in XAMPP?

STEP 1: Open XAMPP

STEP 2: Start the services of Apache and MySQL.

STEP 3: CLICK ON THE DATABASE

STEP 4: Click on “data dictionary” as shown in the figure below;How to view data Dictionary in XAMPP

How to view data Dictionary in XAMPPSTEP 5: Print/view or save the data dictionary

How to check data Dictionary
How to check data Dictionary

 

Topic Covered

A data dictionary is a repository that manages | data dictionary data type in python | a data dictionary is a special file that contains | define data dictionary | what is data dictionary in software engineering | data dictionary example |the data dictionary tells the DBMS | MySql data dictionary | data dictionary for library management system  | data dictionary software engineering | types of data dictionary | data dictionary in system analysis and design | data dictionary is also called | what does the data dictionary identify? | data dictionary in software engineering examples | what is data dictionary in oracle | data dictionary contains | how to create a data dictionary | data dictionary diagram.

Prof.Fazal Rehman Shamil (Available for Professional Discussions)
1. Message on Facebook page for discussions,
2. Video lectures on Youtube
3. Email is only for Advertisement/business enquiries.