Entity Relationship Model

Transform Data into Architecture

01. Do Business Requirement Analysis of the Project.
     01. Understand Business and Domain Knowledge.
     02. Discuss with the Stockholder and Business Analyst.
     03. Point out Expectation Feature in the New Application.
     04. Review the Existing Documents.
     05. Review the Existing Reports.
     06. Review the Existing Automation Application.

02. Design the Conceptual Data Model with Analyze Document.
     01. Identify and Define Entity Types.
     02. Re-Define CDM with Normalization Technique.
     03. Identify and Define Entity Relationships Degree.
     04. Define Relationships Cardinality, Connectivity and Existence.
     05. Identify and Re-Define Entities with EER Generalization Concept.
     06. Clean Up Many-To-Many Relationships into Binary Relationships
          06.01. Eliminate Redundant Relationships Entity.
          06.02. Introduce Associate Entity in the Simple M:M
          06.03. Introduce Associate Entity in the Complex M:M
          06.04. Introduce Associate Entity in the Multivalued Attribute.

03. Design the Logical Data Model with Normalization Technique.
     01. Identify and Define Attributes.
     02. Identify and Define Simple Key Identifier Attribute.
     03. Identify and Define Component Key Identifier Attributes.
     04. Identify and Define Referential Integrity Key Attributes.
     05. Identify and Define Derived and Decode Attributes.
     06. Identify Data Consistency Problem and Break or Merge Attribute(s).
     07. Evaluate and Re-Define Current LDM with Normalization Technique.
     08. Identify and Define De-Normalization Rules for Database Performance.

04. Design the Physical Data Model with RDBMS Object.
     01. Define Comment on Entity.
     02. Define Data Type on Attribute.
     03. Define Data Size on Attribute.
     04. Define Data Format on Attribute.
     05. Define NULL Domain Constraint.
     06. Define CHECK Domain Constraint.
     07. Define DEFUALT Domain Constraint.
     08. Identify and Define Clustered Index.
     09. Identify and Define Non-Clustered Index.
     10. Transform PDM into SQL Script File Format.

05. Deliver the Data Architect Design and Document.
     01. Deliver SQL Script File into Database Administrator.
     02. Delivery Data Architect Standard Abbreviation Document.
     03. Deliver Logical Data Modeling Data Dictionary Document.

06. Maintain the Data Architect Design and Document.
     01. Discuss with Technical Team and Stockholder.
     02. Find out Missed / New Business Requirement Information.
     03. Update CDM, LDM and PDM Design and Document.
     04. Prepare Change Log Document for Each Data Modeling.

* * * * *

Email Your Comment To AUTHOR