Table of Contents
2.1 : Definition of a Data Model
Model
Representation of a set of business requirements in a standard structured framework understood by the users
Data Model
A collection of concepts that can be used to describe the structure of a database
Most data models include a set of basic operations for query and updates on the database
It is becoming more common to include concepts in the data model to specify the dynamic aspect or behavior defined operations
Data Model Instances
Conceptual Model
Logical Model
Physical Model
2.2 : Data Model Types
Database Model
A database model is a theory or specification describing how a database is structured and used. Several such models have been suggested. Common models include
– Flat model
– Hierarchical model
– Network model
– Relational model:
– Object-relational model
– Dimensional Model
2.3 Data Modeling Stages & Deliverables
2.4: Main Phases of Database Design
2.5: Data Modeling In DWH Environment
2.6: Data Modeling Approaches
2.7: Data Modeling Life Cycle
2.8: Data Models & Zachman Framework
