Chapter 17 — Further Reading

Foundations (🔬 CS Student)

  • Peter Chen, "The Entity-Relationship Model — Toward a Unified View of Data" (1976). The paper that introduced ER modeling and Chen notation. A readable classic; worth seeing the original.
  • Ramakrishnan & Gehrke / Silberschatz — the ER-modeling chapters. Rigorous treatment of entities, relationships, cardinality, participation, weak entities, and ER-to-relational mapping (the bridge to Chapter 18).
  • Elmasri & Navathe, Fundamentals of Database Systems — the conceptual-modeling chapters. Especially thorough on ER and EER (extended ER: specialization/generalization).

Practical modeling (💻 Developer · 🏗️ DBA)

  • Crow's-foot notation guides. Most modeling tools use it; learn to read the symbols fluently.
  • Diagramming tools: dbdiagram.io (text-to-diagram, great for quick ER sketches), draw.io / Lucidchart (general), DBeaver / pgAdmin (reverse-engineer an ER diagram from an existing database — try it on Mercado).
  • Articles on "common data modeling patterns" — order-items, hierarchies, tagging, user-roles. Pairs with Chapter 21.

On modeling judgment (everyone)

  • "Many-to-many relationships and junction tables" explainers — the single most important relational-modeling concept (Case Study 2).
  • "Entity vs. attribute: when does a thing deserve its own table?" Good for the course/section-style distinctions (Case Study 1).
  • Joe Celko, SQL for Smarties — opinionated, deep takes on modeling decisions.

Reference (this book)

  • Appendix B — The Mercado Practice Database: a complete, worked ER diagram + data dictionary to study as a model.
  • Chapter 18 (next): the ER-to-tables mapping rules.
  • Chapter 21 (Data Modeling Patterns): the reusable patterns named here, in depth.

Do, don't just read

  • Reverse-engineer Mercado's ER diagram with DBeaver or pgAdmin and compare it to Appendix B. Seeing a real schema as a diagram cements the concepts.
  • Model a domain you know well (a gym, a recipe site, a sports league) end to end: entities, attributes, relationships, cardinality, participation, M:N junctions. Then critique it.
  • Draw your project's ER diagram (the progressive-project exercise) before Chapter 18 turns it into tables.

Next: Chapter 18 — From ER Diagram to Tables: turning your model into DDL.