@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix schema: <https://schema.org/> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .

<https://knobit.org/id/task/dm-design-schemes/C1> a edu:Question ;
    rdfs:label "C1 (2 points)"@en ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    schema:hasPart <https://knobit.org/id/register/data-modelling#I-2401> ;
    schema:identifier "C1" ;
    schema:position 1 ;
    schema:text "Star schema for a stated grain, 1 each: (a) the fact is at one row per approved authorisation (auth_id as a degenerate dimension), its additive measures are billing_amount_eur and interchange_fee_eur at that grain, the transaction-currency amount is not treated as additive across currencies, and the dimension keys are date, card, merchant and account - with dim_date and dim_account the bank's existing conformed dimensions, reused rather than redesigned; (b) nothing at a coarser grain sits in the fact: the monthly card fee (card-month) is kept out - its own fact, or excluded with the reason - and declined authorisations are outside the grain."@en .

edu:Question rdfs:label "Question"@en,
        "Küsimus"@et .

<https://knobit.org/id/register/data-modelling#I-2401> rdfs:label "dm-design-schemes C1: star schema for card authorisations"@en .