@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-603 a edu:Knobit ;
    rdfs:label "Recognises a stored derived or summary value"@en ;
    dcterms:identifier "K-603",
        "Q-382" ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    dcterms:source "Review checklist 04-physical, row 3; C&B (\"design representation of derived data\"); E&N 17.7; S&W 12.6"@en,
        "Shared-URI copy of data-modelling K-603 (Review checklist 04-physical (data-modelling), row 3; C&B (\"design representation of derived data\"); E&N 17.7; S&W 12.6)"@en ;
    owl:sameAs <https://bitbucket.org/reffa/ontology/id/knobit/data-modelling/06-physical/03> ;
    skos:altLabel "Stored derived or summary value (physical model)"@en ;
    skos:definition "A column or table holding a value computed from other stored data, written separately from its inputs, so the two can disagree. The physical form of logical row 10."@en ;
    skos:prefLabel "Recognises a stored derived or summary value"@en ;
    edu:actionVerb "Recognises"@en ;
    edu:appliesKnowledge knobit:K-565 ;
    edu:assessmentCriterion "Flags the deficient case and passes the acceptable one. Deficient: `loan.total_repayment_amount` kept by the application alongside `instalment`; an instalment is corrected and the total is not. `account_balance_monthly_total` reloaded nightly, with nothing saying as of when Acceptable: A generated column or a view; otherwise `derivation` naming the rule and the refresh mechanism, and a DQ rule comparing stored and computed values. A summary table carries its as-of timestamp"@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/aiGeneratedAiEdited>,
        <https://knobit.org/def/creationMethod/aiGeneratedHumanEdited> ;
    edu:dependsOnKnobit knobit:K-510 ;
    edu:expectedResult "The value, its inputs and the derivation or check 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 "stored computed column or table"@en ;
    schema:creativeWorkStatus "accepted" ;
    schema:isPartOf register:data-modelling,
        register:data-quality .

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

knobit:K-510 rdfs:label "Recognises a stored derivable attribute"@en .

knobit:K-565 rdfs:label "Explains derived data and point-in-time snapshots"@en .