Cheat sheets

DB-02Cheat sheet1 pageIn a paid pack

ER Model: Notation and Constructs

Chen notation for entity sets, weak entity sets, relationships and identifying relationships; the attribute kinds (simple, composite, multivalued, derived, key, partial key); relationship degree and role names; cardinality ratio versus participation and the (min, max) notation, which places its labels on the opposite side from the ratio; weak entities and their owners; specialization, generalization and aggregation; and why a ternary relationship is not three binary ones.

Diagrams from DB-02

DB-03Cheat sheet1 pageIn a paid pack

ER to Tables and Minimum Tables

The mapping rule for each ER construct: strong and weak entities, composite, multivalued and derived attributes, binary 1 : 1, 1 : N and M : N relationships with total or partial participation, recursive and n-ary relationships, and the three ways to map a specialization. A worked fragment shows the six tables it produces, and a counting formula with script-checked cases answers minimum-table questions, including the 1 : 1 cases where the answer depends on participation and on the textbook's convention.

Diagrams from DB-03