Explains referential integrity and referential actions

K-653 · Knowledge knobit · Activity: Design the physical data model · Competence: Data modelling

Foreign keys, and what cascade, set-null and restrict do to children.

Can AI do this?

Not tested yet

No AI benchmark covers this knobit yet. New results are announced in the Can AI Do the Job? newsletter.

What it looks like in practice

Expected result: Foreign keys, and what cascade, set-null and restrict do to children

How it is assessed: Chooses the referential action for sample relationships

Related knobits

Builds on

• K-567 Explains relationship cardinality and optionality

Needed for

• K-612 Recognises an undeclared foreign key
• K-613 Recognises a referential action destroying what should survive
• K-625 Recognises a soft delete the constraints do not understand
• K-628 Recognises a nullable foreign key on a reporting join path
• K-814 Recognises a foreign-key cycle taken as resolved

All 40 knobits of Design the physical data model.

Source: Data-management practice used by the stage 6 reference and review checklist