| Home >Tutorial > Entity Relational Modeling vs. Dimensional Modeling > Data Modeling Development Cycle |
|
| Entity Relational Modeling vs. Dimensional Modeling |
| |
| Data Modeling Development Cycle |
| |
- Gathering Business Requirements - First Phase: Data Modelers have to interact with business analysts to get the functional requirements and with end users to find out the reporting needs.
- Conceptual Data Modeling(CDM) - Second Phase: This data model includes all major entities, relationships and it will not contain much detail about attributes and is often used in the INITIAL PLANNING PHASE.
- Logical Data Modeling(LDM) - Third Phase:
This is the actual implementation of a conceptual model in a logical data model. A logical data model is the version of the model that represents all of the business requirements of an organization.
- Physical Data Modeling(PDM) - Fourth Phase: This is a complete model that includes all required tables, columns, relationship, database properties for the physical implementation of the database.
|
Conceptual Data Modeling(CDM) |
 |
| Logical Data Modeling(LDM) |
 |
| Physical Data Modeling(PDM) |
 |
| |
|