knobit.org

Recognises a chasm trap

edu:Knobit

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

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

Context functionsResult evaluation
Knobit creation methodsAI generated, human edited
Knobit typesSkill
LCG purposesAssessing the learner's knowledge or skill state
LCG purposesSelecting an assessment task or learning activity
action verbRecognises en
applies knowledgeExplains the connection, fan and chasm traps
assessment criterionFlags the deficient case and passes the acceptable one. Deficient: Branch 1:N Account Manager 1:N Account with Account → Account Manager optional: accounts opened online have no path to a branch and vanish from branch totals (row 24's fix can create this) Acceptable: A direct Account → Branch relationship, or a direct-channel branch, so every account reaches exactly one en
assessment methodskill-tests task: Loan application logical model (normalisation anomaly skills) en
dcterms:identifierK-525
dcterms:licensehttps://creativecommons.org/licenses/by/4.0/
dcterms:sourceReview checklist 03-logical, row 25; Howe; C&B en
expected resultThe path, the optional relationship on it, and the instances that drop out en
rdfs:labelRecognises a chasm trap en
schema:creativeWorkStatusaccepted
schema:isPartOfData modelling (DAMA-DMBOK2)
skos:altLabelChasm trap (logical model) en
skos:definitionA path exists, but an optional relationship on it breaks it for some instances, so they silently drop out of every query that follows the path. en
skos:prefLabelRecognises a chasm trap en
target objectchasm trap en

Used by

depends on knobitRecognises a nullable foreign key on a reporting join path
includes knobitDerives a normalised logical data model and traces anomalies to their causes
requires knobitDerive the logical data model