Recognises independent multi-valued facts in one entity

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

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 multivalued dependency and fourth normal form
assessment criterion	Flags the deficient case and passes the acceptable one. Deficient: Branch Capability (Branch, Product, Language), where the products a branch may sell and the languages its staff serve in are unrelated Acceptable: Branch Product Authorisation (Branch, Product) and Branch Service Language (Branch, Language) 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-512
dcterms:license	https://creativecommons.org/licenses/by/4.0/
dcterms:source	Review checklist 03-logical, row 12; Fagin 1977; Kent 1983; S&W 13.4 en
expected result	The two independent lists and the entity that combines them en
owl:sameAs	https://bitbucket.org/reffa/ontology/id/knobit/data-modelling/05-logical/12
rdfs:label	Recognises independent multi-valued facts in one entity en
schema:creativeWorkStatus	accepted
schema:isPartOf	Data modelling (DAMA-DMBOK2)
skos:altLabel	Independent multi-valued facts in one entity (4NF) (logical model) en
skos:definition	One entity records two or more independent lists about the same thing, so each new item in one list needs a row for every item in the other. en
skos:prefLabel	Recognises independent multi-valued facts in one entity en
target object	independent multi-valued facts in one entity en

Used by

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