Model Data Object
This module covers conceptual data models, normalization, and data model
validation.
It aims to equip you with the skills to design ER diagrams, apply
normalization rules, and validate data models.
AT
by Addisu Tesfa
Analyzing Business Operations
Understand Business Operations Analyzing Business Operations
Cyclic activities that harvest value. Operational analysis helps understand processes.
Tangible and intangible assets like buildings or ideas generate Measures performance and explores improvements in
income and value. efficiency and cost-effectiveness.
Major Data Analysis
Methods
Text Analysis Statistical Diagnostic
Analysis Analysis
Predictive
Analysis
Different methods to transform raw data into actionable insights for
strategic business decisions.
Scope of the System
Define System Scope
Identifies what a system includes or excludes.
Clarify Boundaries
Identifies start and end points of the system.
Databases
Applications
Must communicate detail to all participants.
Entities and Attributes
Entity Attribute
A real-world object about which data is stored. (e.g., school, A characteristic describing an entity. (e.g., Employee's name,
student) age, address)
Entities are like tables, and attributes are columns in a database.
Normalization Steps
1NF
Eliminate repeating groups.
2NF
Eliminate redundant data.
3NF
Eliminate columns not dependent on keys.
Normalization reduces data redundancy and improves data integrity.
Data Model Validation
Validation Validation w/ Client
Ensures the model meets requirements. Confirms accuracy and completeness.
Validates the model's usefulness. Achieves requirements alignment.
Resolve Issues & Client
Approval
Resolve Issues Client Feedback
Address performance, security, Iterate based on client
or scalability. feedback, seek changes.
Client Approval
Seek client confirmation and acceptance.
