C3 (2 points)
https://knobit.org/id/task/dq-sbvr-rule-anomalies/C3
Also as Turtle · JSON-LD · RDF/XML
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
|---|---|
| rdfs:label | C3 (2 points) en |
| schema:hasPart | dq-sbvr-rule-anomalies C3a: joint account maximum of two holders |
| schema:hasPart | dq-sbvr-rule-anomalies C3b: customer side made optional |
| schema:identifier | C3 |
| schema:position | 3 |
| schema:text | Holder cardinality read in both directions, 1 each: (a) BR-103 (each account held by exactly one customer) contradicts DR-102's joint accounts: an account has at least one and at most two holders, the maximum is stated as a rule, and the single customer_id column is reported as unable to hold two holders (an account holder table or equivalent under physical_changes); (b) BR-104 (each customer holds at least one deposit account) has the wrong optionality - DR-102 allows customers with no deposit account - and is retired, not left in force. en |