Stages of Data Modeling
Conceptual Data Model
Define WHAT the system contains. Used by business stakeholders. The purpose is to organize, scope and define business concepts and rules.
- Entity Relationship Diagram
- Data Dictionaries
Logical Data Model
Defines HOW the system should be implemented regardless of the DBMS. Used by data architects and business analysts. The purpose is to develop technical map of rules and data structures.
- Notmalization and De-Normalization
- Object-oriented Data Modeling
Physical Data Model
Describes HOW the system will be implemented using a specific DBMS system. Used by DBA and developers. The purpose is actual implementation of the database.
- Implementation of a data model in a database management system
- Indexing
- Partitioning