Explains referential integrity and referential actions

https://knobit.org/id/knobit/K-653

Context functions	Object understanding
Knobit creation methods	AI generated
Knobit types	Knowledge
LCG purposes	Assessing the learner's knowledge or skill state
LCG purposes	Opening up a learning outcome
action verb	Explains en
assessment criterion	Chooses the referential action for sample relationships en
assessment method	Written question with sample physical tables en
conforms to profile	https://oppekava.edu.ee/a/Knobitite_kirjeldamise_ja_seostamise_reeglid#LCG-KNOBIT-0.1
dcterms:identifier	K-653
dcterms:license	https://creativecommons.org/licenses/by/4.0/
dcterms:source	Data-management practice used by the stage 6 reference and review checklist en
depends on knobit	Explains relationship cardinality and optionality
expected result	Foreign keys, and what cascade, set-null and restrict do to children en
owl:sameAs	https://bitbucket.org/reffa/ontology/id/knobit/data-modelling/06-physical/K-653
rdfs:label	Explains referential integrity and referential actions en
schema:creativeWorkStatus	accepted
schema:isPartOf	Data modelling (DAMA-DMBOK2)
skos:definition	Foreign keys, and what cascade, set-null and restrict do to children. en
skos:prefLabel	Explains referential integrity and referential actions en
target object	referential integrity en

Used by

applies knowledge	Recognises an undeclared foreign key
applies knowledge	Recognises a referential action destroying what should survive
applies knowledge	Recognises a soft delete the constraints do not understand
applies knowledge	Recognises a nullable foreign key on a reporting join path
applies knowledge	Recognises a foreign-key cycle taken as resolved
includes knobit	Designs a physical data model for the target platform without introducing anomalies
includes knobit	Physical data model
includes knobit	Best practices in database design
includes knobit	Relationship
requires knobit	Design the physical data model