@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@prefix knobit: <https://knobit.org/id/knobit/> .
@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-624 a edu:Knobit ;
    rdfs:label "Recognises a reference to a versioned table by business key alone"@en ;
    dcterms:identifier "K-624",
        "Q-394" ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    dcterms:source "Review checklist 04-physical, row 24; S&W 15.7, 16.6; DDL 2014 ch. 13"@en,
        "Shared-URI copy of data-modelling K-624 (Review checklist 04-physical (data-modelling), row 24; S&W 15.7, 16.6; DDL 2014 ch. 13)"@en ;
    skos:altLabel "Reference to a versioned table by business key alone (physical model)"@en ;
    skos:definition "A foreign key or join to a table with versions that names the business key and not the version, or a code resolved through today's reference data. Each row multiplies by the number of versions, or past rows change meaning when the reference data does."@en ;
    skos:prefLabel "Recognises a reference to a versioned table by business key alone"@en ;
    edu:actionVerb "Recognises"@en ;
    edu:appliesKnowledge knobit:K-658 ;
    edu:assessmentCriterion "Flags the deficient case and passes the acceptable one. Deficient: `fact_payment.account_identifier` joined to `dim_account` on `account_identifier`: one payment becomes three; `customer_segment_code` resolved through today's `ref_customer_segment`, so a 2025 report changes after the segment boundaries are widened Acceptable: The fact references the version key valid at the event date (`account_key`); reference tables carry validity, and the fact stores the code valid at the time"@en ;
    edu:assessmentMethod "skill-tests task: Loan application physical model on Snowflake (physical design anomaly skills)"@en ;
    edu:contextFunction <https://knobit.org/def/contextFunction/resultEvaluation> ;
    edu:creationMethod <https://knobit.org/def/creationMethod/aiGeneratedAiEdited>,
        <https://knobit.org/def/creationMethod/aiGeneratedHumanEdited> ;
    edu:expectedResult "The reference and the version key it needs"@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 "join or foreign key to a versioned table"@en ;
    schema:creativeWorkStatus "accepted" ;
    schema:isPartOf register:data-modelling,
        register:data-quality .

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

knobit:K-658 rdfs:label "Explains history strategies and validity-period conventions"@en .