AlgoPlus//structures / er-model
Read the theory

ER Model

Model the real world as entities and relationships, then reduce the diagram to tables.

Step
1/1
Legend
Entity
Relationship
Key / focus
AI Tutor Workspace
In a nutshell
The entity-relationship model is a picture of the data before any tables exist. You draw the real-world things you care about (entities) as rectangles, the facts about them (attributes) as ovals, and the links between them (relationships) as diamonds, labelling each link with how many connect to how many (cardinality). Then a mechanical recipe turns that diagram into actual tables — which is why join tables appear for many-to-many links.
Ready
Press play to begin the cinematic walkthrough.
The ER model captures a domain as entities (things) and relationships (how they connect), with attributes describing each. It is design-time; reducing it to tables — entities and many-to-many relationships each becoming a relation — is what produces the schema.
Key terms
Go deeper in the lesson
Read the full theory, intuition & complexity for ER Model.