Schema Design & Table Relationships: Overview

Understand four relationship types (1:1, 1:N, M:N, self-referencing)

Design relationships correctly

Master junction tables for many-to-many

Choose appropriate CASCADE options

Understand four relationship types (1:1, 1:N, M:N, self-referencing)

Design relationships correctly

Master junction tables for many-to-many

Choose appropriate CASCADE options