@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@prefix owl: <http://www.w3.org/2002/07/owl#> .
@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/dq-rule-derivation/C1> a edu:Question ;
    rdfs:label "C1 (3 points)"@en ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    owl:sameAs <https://bitbucket.org/reffa/ontology/id/task/dq-rule-derivation/C1> ;
    schema:hasPart <https://knobit.org/id/register/data-quality#QI-350>,
        <https://knobit.org/id/register/data-quality#QI-351>,
        <https://knobit.org/id/register/data-quality#QI-352>,
        <https://knobit.org/id/register/data-quality#QI-353>,
        <https://knobit.org/id/register/data-quality#QI-354> ;
    schema:identifier "C1" ;
    schema:position 1 ;
    schema:text "Stored derived and copied values, the physical model's own DQ obligations: (a) 0.5 - BR-206: available_balance_amount is stored beside ledger_balance_amount and hold_amount, so a row consistency check compares it with ledger_balance_amount - hold_amount (or the column is replaced by a computed one, with the check kept until then); (b) 1 - BR-207: AGG_CUSTOMER_COVERAGE is a stored summary reloaded nightly, so a set check recomputes covered_amount_eur from the balances at the FX rate valid on the balance date and returns the customers that differ (0.5), and the table's missing as-of date is reported - nothing says which balance date it holds, so a failed reload passes yesterday's figures off as today's (0.5); (c) 0.5 - DIM_DEPOSIT_ACCOUNT.interest_rate_at_opening gets no consistency check, as a snapshot meant to differ from interest_rate; earned only together with (a) or (b); (d) 0.5 - holder_residency_country is reported as a copy with nothing keeping it equal to DIM_CUSTOMER.residency_country_code: a customer who moves gets a new customer version and the account row keeps the old country unless the account itself changes; (e) 0.5 - the copy is made controlled: a consistency check compares it with the first holder's current customer version, and a physical finding names the mechanism that refreshes it, or replaces it with a view."@en .

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

<https://knobit.org/id/register/data-quality#QI-350> rdfs:label "dq-rule-derivation C1a: stored available balance checked against ledger less holds"@en .

<https://knobit.org/id/register/data-quality#QI-351> rdfs:label "dq-rule-derivation C1b: summary table recomputed and its missing as-of date reported"@en .

<https://knobit.org/id/register/data-quality#QI-352> rdfs:label "dq-rule-derivation C1c: rate snapshot at opening left without a consistency check"@en .

<https://knobit.org/id/register/data-quality#QI-353> rdfs:label "dq-rule-derivation C1d: residency copied onto the account with nothing keeping it equal"@en .

<https://knobit.org/id/register/data-quality#QI-354> rdfs:label "dq-rule-derivation C1e: copied residency made a controlled denormalisation"@en .