Recognises a partial dependency on a composite key

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

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 second normal form
assessment criterion	Flags the deficient case and passes the acceptable one. Deficient: Instalment keyed by (Loan Identifier, Instalment Number) carries Loan Maturity Date, which depends on Loan Identifier alone Acceptable: Loan Maturity Date on Loan; Instalment holds only facts about the instalment (`LOG-019`) 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-508
dcterms:license	https://creativecommons.org/licenses/by/4.0/
dcterms:source	Review checklist 03-logical, row 8; Codd 1971; Kent 1983; S&W 2.7 en
expected result	The non-key attribute and the part of the key it depends on en
followed by	Decomposes an entity along a functional dependency without loss
owl:sameAs	https://bitbucket.org/reffa/ontology/id/knobit/data-modelling/05-logical/08
rdfs:label	Recognises a partial dependency on a composite key en
schema:creativeWorkStatus	accepted
schema:isPartOf	Data modelling (DAMA-DMBOK2)
skos:altLabel	Partial dependency (2NF) (logical model) en
skos:definition	In an entity with a composite key, a non-key attribute depends on only part of the key. en
skos:prefLabel	Recognises a partial dependency on a composite key en
target object	partial dependency on a composite key en

Used by

followed by	Records the functional dependencies of an entity
includes knobit	Derives a normalised logical data model and traces anomalies to their causes
requires knobit	Derive the logical data model