Schema Design Vocabulary
5 exercises — practise the English vocabulary for schema design discussions: normalization normal forms, denormalization trade-offs, foreign key constraint actions, relationship cardinality, and the soft delete pattern.
Schema design quick reference
- 1NF: no repeating groups — all values must be atomic
- 2NF: no partial dependency — non-key columns depend on the full composite PK
- 3NF: no transitive dependency — non-key columns depend only on the PK
- Denormalization trade-off: redundancy and write anomaly risk in exchange for read speed
- ON DELETE RESTRICT: prevents parent deletion if children reference it
- Many-to-many: always requires a junction table with two foreign keys
Question 1 of