@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-626 a edu:Knobit ;
    rdfs:label "Recognises a fact table of mixed grain"@en ;
    dcterms:identifier "K-626" ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    dcterms:source "Review checklist 04-physical, row 26; C&B (\"Data Warehousing Design\": choosing the grain); E&N 29.3; S&W 16.6"@en ;
    skos:altLabel "Mixed grain (physical model)"@en ;
    skos:definition "A fact or wide table whose rows mean different things, or whose columns are true at different grains. Measures at the coarser grain repeat on every finer row and are counted again when summed."@en ;
    skos:prefLabel "Recognises a fact table of mixed grain"@en ;
    edu:actionVerb "Recognises"@en ;
    edu:appliesKnowledge knobit:K-659 ;
    edu:assessmentCriterion "Flags the deficient case and passes the acceptable one. Deficient: `fact_account_balance` with one row per payment carrying `ledger_balance_amount`, which is per account per day: an account with three payments in a day reports three times its balance Acceptable: A grain sentence, and every column true at that grain; `fact_payment` at payment grain and daily balances on `fact_account_balance_daily` (`PHY-013`, `PHY-028`)"@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/aiGeneratedHumanEdited> ;
    edu:expectedResult "The grains mixed and the measures double counted"@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 "fact or wide table"@en ;
    schema:creativeWorkStatus "accepted" ;
    schema:isPartOf register:data-modelling .

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

knobit:K-659 rdfs:label "Explains grain and additivity in dimensional models"@en .