Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Data Dictionary in DBMS
Data Dictionary consists of database metadata. It has records about objects in the database.
What Data Dictionary consists of
Data Dictionary consists of the following information −
- Name of the tables in the database
- Constraints of a table i.e. keys, relationships, etc.
- Columns of the tables that related to each other
- Owner of the table
- Last accessed information of the object
- Last updated information of the object
An example of Data Dictionary can be personal details of a student −
Example
<StudentPersonalDetails>
| Student_ID | Student_Name | Student_Address | Student_City |
The following is the data dictionary for the above fields −
Types of Data Dictionary
Here are the two types of data dictionary −
Active Data Dictionary
The DBMS software manages the active data dictionary automatically. The modification is an automatic task and most RDBMS has active data dictionary. It is also known as integrated data dictionary.
Passive Data Dictionary
Managed by the users and is modified manually when the database structure change. Also known as non-integrated data dictionary.
Updated on: 15-Jun-2020
5K+ Views
Advertisements