Recognises an insertion anomaly in a logical data model

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

Also as Turtle · JSON-LD · RDF/XML · AI benchmark on Skilirium

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 name held only on Account, so a newly opened branch cannot be recorded until an account is serviced there Acceptable: Branch as a reference entity keyed by Branch Identifier; Account carries only the identifier (cause: row 9) 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-501
dcterms:license	https://creativecommons.org/licenses/by/4.0/
dcterms:source	Review checklist 03-logical, row 1; Codd 1971; Fagin 1981; E&N 14.1.2; C&B en
expected result	The fact that cannot be recorded and the unrelated fact it would need en
owl:sameAs	https://bitbucket.org/reffa/ontology/id/knobit/data-modelling/05-logical/01
rdfs:label	Recognises an insertion anomaly in a logical data model en
schema:creativeWorkStatus	accepted
schema:isPartOf	Data modelling (DAMA-DMBOK2)
skos:altLabel	Insertion anomaly (logical model) en
skos:definition	A fact cannot be recorded without also recording another fact it does not depend on, because it has no entity of its own. en
skos:prefLabel	Recognises an insertion anomaly in a logical data model en
target object	insertion anomaly in a logical data model en

Used by

includes knobit	Derives a normalised logical data model and traces anomalies to their causes
requires knobit	Derive the logical data model