C2 (3 points)

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

dcterms:license	https://creativecommons.org/licenses/by/4.0/
owl:sameAs	https://bitbucket.org/reffa/ontology/id/task/dq-rules/C2
rdfs:label	C2 (3 points) en
schema:hasPart	dq-rules C2a: check on the wrong column
schema:hasPart	dq-rules C2b: check weaker than its rule
schema:hasPart	dq-rules C2c: wrong population
schema:identifier	C2
schema:position	2
schema:text	The three checks that measure the wrong thing, 1 each: (a) DQ-002 cites BR-005, which constrains income, and reads credit_score_at_assessment - the wrong column; (b) DQ-003 is weaker than BR-001, which says each application has exactly one application number and no number is shared: a not-null check lets every duplicate through, so a uniqueness check is needed as well; (c) DQ-007's population is every application, with is_secured = FALSE passing trivially, so a quarter of secured applications failing reports as a pass - the population is narrowed to secured applications and the point is made that the population is also the threshold's denominator. en

Used by

has question	Loan application data quality rules on Snowflake (DQ rule anomaly skills)
schema:isPartOf	dq-rules C2a: check on the wrong column
schema:isPartOf	dq-rules C2b: check weaker than its rule
schema:isPartOf	dq-rules C2c: wrong population