Recognises an undeclared foreign key
https://knobit.org/id/knobit/K-612
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 referential integrity and referential actions |
| assessment criterion | Flags the deficient case and passes the acceptable one. Deficient: `payment.account_id` with no foreign key; an account is purged and its payments point nowhere Acceptable: A `foreign_keys` entry for every logical relationship, citing it in `logical_relationship`; where the platform does not enforce it, see row 15 (`PHY-007` checks the declared ones; a missing one is review only: compare each `LR-` with the foreign keys citing it) en |
| assessment method | skill-tests task: Loan application physical model on Snowflake (physical design anomaly skills) en |
| conforms to profile | https://oppekava.edu.ee/a/Knobitite_kirjeldamise_ja_seostamise_reeglid#LCG-KNOBIT-0.1 |
| dcterms:identifier | K-612 |
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
| dcterms:source | Review checklist 04-physical, row 12; Karwin, Keyless Entry; Codd 1979 §2.1; E&N 5.2, 6.2; S&W 11.6 en |
| expected result | The column and the foreign key to declare en |
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/knobit/data-modelling/06-physical/12 |
| rdfs:label | Recognises an undeclared foreign key en |
| schema:creativeWorkStatus | accepted |
| schema:isPartOf | Data modelling (DAMA-DMBOK2) |
| skos:altLabel | Undeclared foreign key (physical model) en |
| skos:definition | A logical relationship implemented as a column with no foreign key, usually "for load speed" or "the ETL checks it". Rows referencing nothing load, and so do deletions that leave them. A specific form of row 14. en |
| skos:prefLabel | Recognises an undeclared foreign key en |
| target object | relationship column without foreign key en |
Used by
| includes knobit | Designs a physical data model for the target platform without introducing anomalies |
|---|---|
| requires knobit | Design the physical data model |