C2 (2 points)
https://knobit.org/id/task/dq-sbvr-rule-anomalies/C2
Also as Turtle · JSON-LD · RDF/XML
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
|---|---|
| rdfs:label | C2 (2 points) en |
| schema:hasPart | dq-sbvr-rule-anomalies C2a: reversed interest rate dependency restated |
| schema:hasPart | dq-sbvr-rule-anomalies C2b: non-minimal rate key narrowed to the candidate key |
| schema:identifier | C2 |
| schema:position | 2 |
| schema:text | Interest rate keys, 1 each: (a) BR-113 states the dependency backwards - it makes an interest rate value determine its product, term and currency, so no two products or terms could share a rate - and is restated (or retired for a new rule) so that deposit product, agreed term, currency and valid-from date together determine at most one interest rate (DR-108); (b) uk_deposit_rate includes rate_pct, so it is not a candidate key and lets two different rates for the same product, term, currency and valid-from date through: the candidate key is (product_code, term_months, currency, valid_from), rate_pct is a non-prime attribute, and the constraint change is recorded under physical_changes. en |