@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-805 a edu:Knobit ;
    rdfs:label "Rule marked `constraint` with no constraint in the SQL (generated DDL)"@en ;
    dcterms:identifier "K-805" ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    dcterms:source "Review checklist 05-ddl, row 5; this skill (03-data-rules.md)"@en ;
    skos:definition "A live data rule with `enforcement: constraint` whose constraint is nowhere in the generated DDL, because it was never carried into the physical model. The rule register says the database guarantees it; the database has never heard of it, and no DQ rule covers it either."@en ;
    skos:prefLabel "Rule marked `constraint` with no constraint in the SQL (generated DDL)"@en ;
    edu:actionVerb "Recognises"@en ;
    edu:assessmentCriterion "Flags the deficient case and passes the acceptable one. Deficient: `BR-005: a loan's maturity date is after its opening date`, `enforcement: constraint`; `dim_account` has no matching `ck_` in any dialect's output and no DQ rule cites `BR-005` Acceptable: `ck_dim_account_maturity_after_opening` in the model's `check_constraints` and in the SQL; or the rule moved to `enforcement: dq-check` with a DQ rule citing it (`TRC-006`, `DQR-007`)"@en ;
    edu:assessmentMethod "skill-tests task: Generated DDL review, Postgres and Snowflake (DDL review skills)"@en ;
    edu:contextFunction <https://knobit.org/def/contextFunction/resultEvaluation> ;
    edu:creationMethod <https://knobit.org/def/creationMethod/aiGeneratedHumanEdited> ;
    edu:expectedResult "A finding that names the defective generated DDL 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 "generated DDL"@en ;
    schema:creativeWorkStatus "superseded" ;
    schema:isPartOf register:data-modelling ;
    schema:supersededBy knobit:K-310 .

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

knobit:K-310 rdfs:label "Recognises a constraint claimed by a rule and missing from the schema"@en .