@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/dq-sbvr-rule-anomalies/C1> a edu:Question ;
    rdfs:label "C1 (3 points)"@en ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    schema:hasPart <https://knobit.org/id/register/data-quality#QI-250>,
        <https://knobit.org/id/register/data-quality#QI-251>,
        <https://knobit.org/id/register/data-quality#QI-252> ;
    schema:identifier "C1" ;
    schema:position 1 ;
    schema:text "Enforcement as each platform actually provides it, 1 each: (a) BR-120 claims enforcement constraint through fk_interest_accrual_deposit, a FOREIGN KEY on Delta Lake, where primary and foreign keys are informational and not enforced - reported, and BR-120 becomes dq-check (or etl) with the DQ rule or load check recorded under physical_changes; (b) BR-107 (the principal must not change after opening) is a data-update rule (subtype prohibition), not data-content range, and no declarative constraint can enforce it - enforcement becomes application (e.g. a BEFORE UPDATE trigger), etl or dq-check, naming what implements it; (c) BR-105 (a PostgreSQL foreign key) and BR-121 (a Delta Lake CHECK constraint, which Delta does enforce) stay on enforcement constraint - this part earns its point only if (a) is also earned."@en .

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

<https://knobit.org/id/register/data-quality#QI-250> rdfs:label "dq-sbvr-rule-anomalies C1a: foreign key on Delta Lake not trusted as enforcement"@en .

<https://knobit.org/id/register/data-quality#QI-251> rdfs:label "dq-sbvr-rule-anomalies C1b: change-over-time rule classified as data-update with a mechanism"@en .

<https://knobit.org/id/register/data-quality#QI-252> rdfs:label "dq-sbvr-rule-anomalies C1c: enforced PostgreSQL foreign key and Delta CHECK kept as constraints"@en .