Welcome to Shaun Luttin's public notebook. It contains rough, practical notes. The guiding idea is that, despite what marketing tells us, there are no experts at anything. Sharing our half-baked ideas helps everyone. We're all just muddling thru. Find out more about our work at bigfont.ca.

Conceptual vs Logical vs Physical Entity Relationship Diagrams

Tags: database, entity-framework

Conceptual

  • has the least detail of the three models
  • contains the organization's "master entities"
  • describes the information that the system will require
  • sometimes acts as the basis for the logical model

Logical

  • has more detail than a conceptual model
  • master, operational, and transactional entities
  • relationships among these entities
  • does not require a conceptual model
  • is technology independent

Physical

  • contains enough detail to instantiate a database
  • is technology dependent