Database Modeling
Database modeling is the process of creating a visual representation of a database’s structure. It helps designers understand data requirements, relationships, and constraints before implementation.
Modeling Levels
- Conceptual Model – High‑level overview of entities and relationships.
- Logical Model – Detailed definition of tables, columns, primary and foreign keys.
- Physical Model – Implementation specifics such as indexes, partitions, and storage engines.
Common Techniques
- Entity‑Relationship (ER) Diagrams
- Unified Modeling Language (UML) Class Diagrams
- Normalization
- Dimensional Modeling for data warehousing
ER Diagram Example
Normalization Forms
| Form | Goal |
|---|---|
| 1NF | Eliminate repeating groups |
| 2NF | Remove partial dependencies |
| 3NF | Remove transitive dependencies |
| BCNF | Handle remaining anomalies |