Constraint the platform does not enforce (physical model)

https://knobit.org/id/knobit/K-615

Also as Turtle · JSON-LD · RDF/XML · AI benchmark on Skilirium

Context functions	Result evaluation
Knobit creation methods	AI generated, human edited
Knobit types	Skill
LCG purposes	Assessing the learner's knowledge or skill state
LCG purposes	Selecting an assessment task or learning activity
action verb	Recognises en
assessment criterion	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
assessment method	skill-tests task: Loan application physical model on Snowflake (physical design anomaly skills) en
conforms to profile	https://oppekava.edu.ee/a/Knobitite_kirjeldamise_ja_seostamise_reeglid#LCG-KNOBIT-0.1
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
expected result	A finding that names the defective physical model element and the defect en
owl:sameAs	https://bitbucket.org/reffa/ontology/id/knobit/data-modelling/06-physical/15
rdfs:label	Constraint the platform does not enforce (physical model) en
schema:creativeWorkStatus	superseded
schema:isPartOf	Data modelling (DAMA-DMBOK2)
schema:supersededBy	Recognises a declared constraint the target platform does not enforce
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
target object	physical model en