Data Model
  • is defined as an abstract model that organizes data description, data semantics, and consistency constraints of data
  • emphasizes what data is needed and how it should be organized instead of what operations will be performed on data
  • is like an architect’s building plan, which helps to build conceptual models and set a relationship between data items

Data Modeling Technique Types

Data Model - Types

Conceptual Data Model

Logical Data Model

Physical Data Model

Example

Description

  • defines WHAT the system contains
  • the purpose is to organize, scope, and define business concepts and rules
  • defines HOW the system should be implemented regardless of the DBMS
  • the purpose is to develop a technical map of rules and data structures
  • describes HOW the system will be implemented using a specific DBMS system
  • the purpose is the actual implementation of the database

Used By

  • Business Stakeholders
  • Data Architects
  • Data Architects
  • Business Analysts
  • DBA
  • Developers