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.
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 XAMPPSTEP 5: Print/view or save the 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.
