Recognises an unstable or meaningful primary key
https://knobit.org/id/knobit/K-517
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 natural keys, surrogate keys and key stability |
| applies knowledge | Explains how database tables and relationships are structured |
| assessment criterion | Flags the deficient case and passes the acceptable one. Deficient: Account keyed on branch code plus sequence: a branch merger renumbers the branches and with them every key; Party keyed on name Acceptable: Account keyed on its IBAN, assigned once and never reused; Branch Identifier as a plain attribute; where no stable natural key exists, say so and record the matching rule (`LOG-005`, `LOG-020`, `LOG-021`, `LOG-027`) 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-517 |
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
| dcterms:source | Review checklist 03-logical, row 17; Codd 1970; Codd 1979; S&W ch. 6 en |
| expected result | The key and how it can change, be reused, be unknown or carry meaning en |
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/knobit/data-modelling/05-logical/17 |
| rdfs:label | Recognises an unstable or meaningful primary key en |
| schema:creativeWorkStatus | accepted |
| schema:isPartOf | Data modelling (DAMA-DMBOK2) |
| skos:altLabel | Unstable or meaningful key (logical model) en |
| skos:definition | The key can change, be reused or be unknown when the row is created, or it carries meaning that can change. Every reference to the row breaks when it does. en |
| skos:prefLabel | Recognises an unstable or meaningful primary key en |
| target object | unstable or meaningful primary key en |
Used by
| depends on knobit | Recognises a surrogate value with meaning, reused or renumbered |
|---|---|
| includes knobit | Derives a normalised logical data model and traces anomalies to their causes |
| requires knobit | Derive the logical data model |