Model Data Object
This presentation covers conceptual data models, normalization, and data
model validation.
AT
by Addisu Tesfa
Module Objectives
1 Identify Elements
Entities, attributes, data types, relationships.
2 ER Diagram
Design an Entity Relationship diagram.
3 Normalization
Apply normalization rules to tables.
4 Validation
Validate data model.
Conceptual Data Model
Business Data System Scope
Analyze business data Understand the scope of the
operations. system.
Define Elements
Identify entities, attributes, data types, relationships.
Analyzing Business
Operations
Recurring Income
Asset Value
Secure Value
Business operations generate income, increase asset value, and secure
business value.
Major Data Analysis Methods
Text Analysis
Discover patterns in large datasets.
Statistical Analysis
Collection, analysis, interpretation, modeling.
Diagnostic Analysis
Identify behavior patterns of data.
Predictive Analysis
Make predictions about future outcomes.
Normalization Rules
1 1NF
Eliminate repeating groups.
2 2NF
Eliminate redundant data.
3 3NF
Eliminate columns not dependent on keys.
4 BCNF
Every determinant must be a candidate key.
Data Model Validation
Collaboration Requirements
1
Involve client throughout process. Align with client objectives.
2
Accuracy 4 Review
Ensure completeness. 3 Present model for feedback.
Client Approval Submission
Presentation
Create clear presentation.
Walkthrough
Explain data model.
Seek Approval
Formally request approval.
