Logical Data Model

  • Entity relationship diagrams.
  • Description of core business entities.
  • Relationship definitions.

Physical Data Model

For each table, capture:

  • Table name and purpose.
  • Column definitions (name, datatype, nullable).
  • Primary and foreign keys.
  • Indexing strategy.

Table template:

Table Purpose Notes
     

Column template:

Column Datatype Nullable Description
       

Dimensional Model

  • Fact tables and grain definitions.
  • Dimension tables.
  • Slowly Changing Dimension approach.

Data Dictionary

  • Definitions for all data fields.
  • Definitions for derived fields.
  • Definitions for KPIs and metrics.
  • Business-friendly descriptions and calculation logic.