Conceptual Data Model

A conceptual data model identifies the highest-level relationships between the different entities. Features of conceptual data model include:

• Includes the important entities and the relationships among them.
• No attribute is specified.
• No primary key is specified.

The figure below is an example of a conceptual data model.

Conceptual Data Model

From the figure above, we can see that the only information shown via the conceptual data model is the entities that describe the data and the relationships between those entities. No other information is shown through the conceptual data model.

• Data Warehouse
• Data Warehouse Definition
• Data Warehousing Concepts
  • Dimensional Data Model
  • Star Schema
  • Snowflake Schema
  • Fact Table Granularity
  • Fact And Fact Table Types
  • Slowly Changing Dimension
  • Type 1 Slowly Changing Dimension
  • Type 2 Slowly Changing Dimension
  • Type 3 Slowly Changing Dimension
  • Type 4 Slowly Changing Dimension
  • Conceptual Data Model
  • Logical Data Model
  • Physical Data Model
  • Conceptual, Logical, and Physical Data Model
  • Data Integrity
  • What Is OLAP
  • MOLAP, ROLAP, and HOLAP
  • Bill Inmon vs. Ralph Kimball
  • Factless Fact Table
  • Junk Dimension
  • Conformed Dimension
• Data Warehouse Design
• Data Warehousing Trends
• Business Intelligence
• Business Intelligence Software
• Business Intelligence Conferences
• Master Data Management
• Data Warehousing Videos
• Glossary
• Site Map
• Resources