Recognises a deletion anomaly in a logical data model

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

Context functions	Result evaluation
Knobit creation methods	AI generated, human edited
Knobit types	Skill
LCG purposes	Assessing the learner's knowledge or skill state
LCG purposes	Selecting an assessment task or learning activity
action verb	Recognises en
applies knowledge	Explains the insertion, update and deletion anomalies
assessment criterion	Flags the deficient case and passes the acceptable one. Deficient: Branch BIC held only on Account; the branch's last account is closed and purged and the BIC goes with it Acceptable: Branch holds the BIC; Account references Branch en
assessment method	skill-tests task: Loan application logical model (normalisation anomaly skills) en
conforms to profile	https://oppekava.edu.ee/a/Knobitite_kirjeldamise_ja_seostamise_reeglid#LCG-KNOBIT-0.1
dcterms:identifier	K-503
dcterms:license	https://creativecommons.org/licenses/by/4.0/
dcterms:source	Review checklist 03-logical, row 3; Codd 1971; Fagin 1981; E&N 14.1.2; C&B en
expected result	The deletion and the fact that would be lost with it en
owl:sameAs	https://bitbucket.org/reffa/ontology/id/knobit/data-modelling/05-logical/03
rdfs:label	Recognises a deletion anomaly in a logical data model en
schema:creativeWorkStatus	accepted
schema:isPartOf	Data modelling (DAMA-DMBOK2)
skos:altLabel	Deletion anomaly (logical model) en
skos:definition	Deleting one fact deletes another that should have survived. en
skos:prefLabel	Recognises a deletion anomaly in a logical data model en
target object	deletion anomaly in a logical data model en

Used by

depends on knobit	Recognises a referential action destroying what should survive
includes knobit	Derives a normalised logical data model and traces anomalies to their causes
requires knobit	Derive the logical data model