Entity Relational Modeling
vs.
Dimensional Modeling

Steps to create a Data Model

• Get Business requirements.
  
  
• Create High Level Conceptual Data Model.
  
  
• Create Logical Data Model.
  
  
• Select target DBMS where data modeling tool creates the physical schema.
  
  
• Create domain.
  
  
• Create Entity and add definitions.
  
  
• Create attribute and add definitions.
  
  
• Assign datatype to attribute. If a domain is already present then the attribute should be attached to the domain.
  
  
• Create primary or unique keys to attribute.
  
  
• Create check constraint or default to attribute.
  
  
• Create unique index or bitmap index to attribute.
  
  
• Create foreign key relationship between entities.
  
  
• Create Physical Data Model.
  
  
• Add database properties to physical data model.
  
  
• Create SQL Scripts from Physical Data Model and forward that to DBA.
  
  
• Maintain Logical & Physical Data Model.

Back to Entity Relational Modeling   vs.  Dimensional Modeling Index