Recognises logical entities merged into one table
https://knobit.org/id/knobit/K-602
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 controlled denormalisation |
| assessment criterion | Flags the deficient case and passes the acceptable one. Deficient: `account` absorbs `branch` (`branch_id`, `branch_name`); a newly opened branch cannot be recorded until an account is serviced there, and deleting the last account serviced there deletes the name Acceptable: `ref_branch` stays the system of record; a merged structure exists only as a dimension or view built from 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-602 |
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
| dcterms:source | Review checklist 04-physical, row 2; Codd 1971; Kent 1983; Fagin 1981; C&B; S&W 12.6 en |
| depends on knobit | Recognises a transitive dependency between non-key attributes |
| expected result | The merged entities and the facts they now tie together en |
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/knobit/data-modelling/06-physical/02 |
| rdfs:label | Recognises logical entities merged into one table en |
| schema:creativeWorkStatus | accepted |
| schema:isPartOf | Data modelling (DAMA-DMBOK2) |
| skos:altLabel | Tables merged (physical model) en |
| skos:definition | Two logical entities, usually a parent or reference entity and its child, stored as one table. One kind of fact can no longer be recorded without the other, and deleting the last child deletes the parent. en |
| skos:prefLabel | Recognises logical entities merged into one table en |
| target object | parent and child merged en |
Used by
| includes knobit | Designs a physical data model for the target platform without introducing anomalies |
|---|---|
| requires knobit | Design the physical data model |