Recognises a foreign-key cycle taken as resolved
https://knobit.org/id/knobit/K-814
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: `dim_account.primary_card_key` → `dim_card` and `dim_card.account_key` → `dim_account`, both `NOT NULL`; the DDL deploys and the first load has no row it can insert first Acceptable: One direction made optional, or the "primary card" relationship moved into its own table. The cycle is resolved in the logical model, not worked around in the load (the header note is a prompt, not a solution) en |
| assessment method | skill-tests task: Generated DDL review, Postgres and Snowflake (DDL review skills) en |
| conforms to profile | https://oppekava.edu.ee/a/Knobitite_kirjeldamise_ja_seostamise_reeglid#LCG-KNOBIT-0.1 |
| dcterms:identifier | K-814 |
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
| dcterms:source | Review checklist 05-ddl, row 14; ISO 9075; this skill (08-ddl.md) en |
| expected result | The cycle and the load order or deferral it needs en |
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/knobit/data-modelling/08-ddl/14 |
| rdfs:label | Recognises a foreign-key cycle taken as resolved en |
| schema:creativeWorkStatus | accepted |
| schema:isPartOf | Data modelling (DAMA-DMBOK2) |
| skos:altLabel | Foreign-key cycle fallback treated as resolved (generated DDL) en |
| skos:definition | The header note saying all tables are created first and every foreign key added afterwards as `ALTER TABLE`. The script runs; the design does not. Two tables each mandatory to the other cannot be loaded without deferring a constraint, and not every engine can defer one. en |
| skos:prefLabel | Recognises a foreign-key cycle taken as resolved en |
| target object | foreign keys added after table creation en |
Used by
| includes knobit | Generates DDL per target dialect and reviews it against model, engine, data and deployment |
|---|---|
| requires knobit | Generate and review DDL |