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)

Back to Entity Relational Modeling   vs.  Dimensional Modeling Index