Recognises a functional dependency lost in a decomposition

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

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 dependency preservation
assessment criterion	Flags the deficient case and passes the acceptable one. Deficient: After row 11's split, nothing says a loan has only one collections officer per product family Acceptable: Either stay in 3NF with a waiver naming the accepted anomaly, or record the dependency as a data rule with `enforcement: application` or `dq-check` 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-515
dcterms:license	https://creativecommons.org/licenses/by/4.0/
dcterms:source	Review checklist 03-logical, row 15; Rissanen 1977; E&N ch. 15 en
expected result	The dependency that now spans two entities and that no key enforces en
owl:sameAs	https://bitbucket.org/reffa/ontology/id/knobit/data-modelling/05-logical/15
rdfs:label	Recognises a functional dependency lost in a decomposition en
schema:creativeWorkStatus	accepted
schema:isPartOf	Data modelling (DAMA-DMBOK2)
skos:altLabel	Dependency lost in decomposition (logical model) en
skos:definition	After a split, a dependency spans two entities and no key in either one enforces it. Typical after a BCNF split (row 11). en
skos:prefLabel	Recognises a functional dependency lost in a decomposition en
target object	functional dependency lost in a decomposition en

Used by

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