Chapter 1
Database Fundamentals
Course: Comptia Datasys Ds0 001
Subject: Comptia Datasys Plus Ds0 001
Chapter: Database Management And Maintenance
1. Data Dictionaries
Definition:
A data dictionary is a structured, centralized repository of metadata that defines and documents data elements in a database system. It serves as the "source of truth" for understanding the structure, usage, lineage, and business context of each data element.
Purpose:
- Enforce consistency across development, analytics, and reporting by standardizing naming conventions and data types.
- Help teams understand schema and relationships without needing to query the database.
- Improve data governance, auditing, and regulatory compliance (e.g., GDPR, HIPAA, SOX).
- Aid in ETL development, reporting layer design, and data quality control.
Contents Typically Include:
| Field Name | Data Type | Description | Constraints | Example Value | | user_id | INT | Unique identifier for users | Primary Key | 10045 | | email | VARCHAR(255) | Email address of the user | UNIQUE, NOT NULL | [email protected] | | created_at | DATETIME | Account creation timestamp | DEFAULT CURRENT_TIME | 2023-01-15 10:33:00 | | is_active | BOOLEAN | Indicates if account is active | DEFAULT TRUE | TRUE |