Stage 6: Design the physical data model
Knobit of Data modelling · K-653 · Knowledge
Explains referential integrity and referential actions
What it means
Foreign keys, and what cascade, set-null and restrict do to children.
How it is assessed
Chooses the referential action for sample relationships
Builds on
- Explains relationship cardinality and optionalityK-567 · Knowledge
Needed by
- Recognises an undeclared foreign keyK-612 · Skill
- Recognises a referential action destroying what should surviveK-613 · Skill
- Recognises a soft delete the constraints do not understandK-625 · Skill
- Recognises a nullable foreign key on a reporting join pathK-628 · Skill
- Recognises a foreign-key cycle taken as resolvedK-814 · Skill