@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-615 a edu:Knobit ;
    rdfs:label "Constraint the platform does not enforce (physical model)"@en ;
    dcterms:identifier "K-615" ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    dcterms:source "Review checklist 04-physical, row 15; this skill (08-ddl.md); Fagin 1981"@en ;
    owl:sameAs <https://bitbucket.org/reffa/ontology/id/knobit/data-modelling/06-physical/15> ;
    skos:definition "A primary key, unique or foreign key declared on Snowflake or Databricks, which accept the syntax and check nothing, with no DQ rule doing the checking. The constraint documents the intent and enforces nothing."@en ;
    skos:prefLabel "Constraint the platform does not enforce (physical model)"@en ;
    edu:actionVerb "Recognises"@en ;
    edu:assessmentCriterion "Flags the deficient case and passes the acceptable one. Deficient: `uk_dim_account_nk` on Snowflake and no `uniqueness` DQ rule; a rerun load duplicates every version Acceptable: Constraint kept (emitted `NOT ENFORCED`, still read by optimisers and BI tools), plus a `uniqueness` or `integrity` DQ rule per constraint citing it in `backs`, and an inferred-member row for each dimension so facts never need an orphan key (`DQR-017`, `DQR-018`)"@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/aiGeneratedHumanEdited> ;
    edu:expectedResult "A finding that names the defective physical model element and the defect"@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 "physical model"@en ;
    schema:creativeWorkStatus "superseded" ;
    schema:isPartOf register:data-modelling ;
    schema:supersededBy knobit:K-313 .

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

knobit:K-313 rdfs:label "Recognises a declared constraint the target platform does not enforce"@en .