knobit.org

C2 (3 points)

edu:Question

https://knobit.org/id/task/data-rules/C2

Also as Turtle · JSON-LD · RDF/XML

dcterms:licensehttps://creativecommons.org/licenses/by/4.0/
owl:sameAshttps://bitbucket.org/reffa/ontology/id/task/data-rules/C2
rdfs:labelC2 (3 points) en
schema:hasPartdata-rules C2a: uniqueness with no unique constraint
schema:hasPartdata-rules C2b: mandatory rule on a nullable column with legacy nulls
schema:hasPartdata-rules C2c: dq-check rule cited by no check
schema:identifierC2
schema:position3
schema:textEnforcement claims made true against the physical model and DQ rules, 1 point each: (a) BR-003 uniqueness of the customer identification code has no unique constraint behind it; (b) BR-017 mandatory monthly income claims a constraint on a nullable column, and because 312 migrated records are null it becomes a dq-check with a threshold below 100% (or NOT NULL only after the legacy records are fixed); (c) BR-022 is assigned to a dq-check that no DQ rule cites. Each needs the gap reported and a stage 6 change (or an honest enforcement) recorded. en

Used by

has questionLoan application data rules (data rule anomaly skills)
schema:isPartOfdata-rules C2a: uniqueness with no unique constraint
schema:isPartOfdata-rules C2b: mandatory rule on a nullable column with legacy nulls
schema:isPartOfdata-rules C2c: dq-check rule cited by no check