Entity-Relationship Model
A data modeling technique that describes entities, their attributes, and the relationships between them using diagrams.
Also known as: ER Model, ER Diagram, ERD, Entity-Relationship Diagram
Category: Frameworks
Tags: data, software-development, modeling, databases, information-architecture
Explanation
The Entity-Relationship (ER) Model is a conceptual data modeling framework introduced by Peter Chen in 1976. It provides a visual and logical way to describe the structure of a database or information system by identifying the key entities (things), their attributes (properties), and the relationships (connections) between them.
The core components are straightforward. Entities represent real-world objects or concepts—a Customer, an Order, a Product. Attributes describe properties of entities—a Customer has a Name, Email, and Address. Relationships define how entities connect—a Customer 'places' an Order, an Order 'contains' Products. Relationships have cardinality (one-to-one, one-to-many, many-to-many) that constrains how entities can be related.
ER diagrams (ERDs) visualize these components using standardized notation: rectangles for entities, ovals for attributes, diamonds for relationships, and lines showing cardinality. This visual representation bridges the gap between business stakeholders (who think in terms of real-world concepts) and database designers (who think in terms of tables and constraints). An ER model serves as a blueprint that can be translated into a physical database schema.
Beyond database design, ER modeling is a valuable thinking tool for understanding any domain. When you model a problem as entities and relationships, you're forced to identify what the key 'things' are, what properties matter, and how they connect—essentially creating an ontology of the problem space. This discipline applies to knowledge management (notes as entities, links as relationships), software architecture (domain-driven design), and business analysis (understanding organizational structures and processes).
Related Concepts
← Back to all concepts