Orientation
What You'll Master Here
Chapter 1 said the conceptual model is where you name the things that exist and how they relate. This chapter teaches you to do exactly that, precisely, using the language every data professional shares: entities, relationships, and cardinality, drawn as an entity-relationship diagram (ERD).
These are the building blocks of every model you will ever make. An entity is a thing you store data about, a relationship is how two things connect, and cardinality is the count rule on that connection (one, many, optional). Get these three right and the tables almost design themselves later.
You will also learn to read and draw crow’s-foot notation, the standard ERD symbols, and to handle the one relationship that trips up almost everyone: many-to-many. By the end you can turn a plain-English description of a business into a correct diagram.
Why it matters
Entities, relationships, and cardinality are the vocabulary of data modeling. Without them, design discussions are vague hand-waving; with them, the whole team can agree on structure before any table exists.
Core mental model
Entities are the nouns, relationships are the verbs, cardinality is the count rule. A diagram is just those three, written down.
- entity
- A thing the business stores data about: customer, order, product.
- relationship
- A meaningful connection between two entities, named with a verb.
- cardinality
- How many instances of one entity relate to one instance of another.
- ERD
- Entity-relationship diagram: the standard picture of entities and their relationships.
Common mistake
Designing tables before agreeing on entities and relationships.
You encode the wrong structure and discover it only after data and code depend on it.
Better habit
- Name entities and relationships before drawing tables.
- State cardinality out loud for every relationship.
- Use an ERD as the shared language with non-engineers.
Nouns become entities, verbs become relationships, and the words "one", "many", and "optional" become cardinality. Modeling at this level is mostly careful reading of requirements.
Each topic adds one symbol to your ERD vocabulary. The final section turns a sentence into a finished diagram, tying it all together.
Practice prompts
- List three entities and two relationships from a food-delivery app.
- For each relationship, say the cardinality in plain English.
Remember this
Entities, relationships, and cardinality are the shared vocabulary of modeling; master them and conceptual design becomes careful reading, not guesswork.