@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@prefix knobit: <https://knobit.org/id/knobit/> .
@prefix owl: <http://www.w3.org/2002/07/owl#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix register: <https://knobit.org/id/register/> .
@prefix schema: <https://schema.org/> .
@prefix skos: <http://www.w3.org/2004/02/skos/core#> .

knobit:K-602 a edu:Knobit ;
    rdfs:label "Recognises logical entities merged into one table"@en ;
    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 ;
    owl:sameAs <https://bitbucket.org/reffa/ontology/id/knobit/data-modelling/06-physical/02> ;
    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 ;
    edu:actionVerb "Recognises"@en ;
    edu:appliesKnowledge knobit:K-651 ;
    edu:assessmentCriterion "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 ;
    edu:assessmentMethod "skill-tests task: Loan application physical model on Snowflake (physical design anomaly skills)"@en ;
    edu:conformsToProfile <https://oppekava.edu.ee/a/Knobitite_kirjeldamise_ja_seostamise_reeglid#LCG-KNOBIT-0.1> ;
    edu:contextFunction <https://knobit.org/def/contextFunction/resultEvaluation> ;
    edu:creationMethod <https://knobit.org/def/creationMethod/aiGeneratedHumanEdited> ;
    edu:dependsOnKnobit knobit:K-509 ;
    edu:expectedResult "The merged entities and the facts they now tie together"@en ;
    edu:graphRelevance <https://knobit.org/def/graphRelevance/learnerState>,
        <https://knobit.org/def/graphRelevance/taskSelection> ;
    edu:knobitType <https://knobit.org/def/knobitType/skill> ;
    edu:targetObject "parent and child merged"@en ;
    schema:creativeWorkStatus "accepted" ;
    schema:isPartOf register:data-modelling .

edu:Knobit rdfs:label "Knobit"@en,
        "Knobit"@et .

knobit:K-509 rdfs:label "Recognises a transitive dependency between non-key attributes"@en .

knobit:K-651 rdfs:label "Explains controlled denormalisation"@en .