C1 (3 points)
https://knobit.org/id/task/dwbi-bus-matrix/C1
Also as Turtle · JSON-LD · RDF/XML
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
|---|---|
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/task/dwbi-bus-matrix/C1 |
| rdfs:label | C1 (3 points) en |
| schema:hasPart | dwbi-bus-matrix C1: two Customer dimensions at different grains called conformed |
| schema:hasPart | dwbi-bus-matrix C1: conformance judged by grain and key |
| schema:hasPart | dwbi-bus-matrix C1: the drill-across consequence for joint holders |
| schema:identifier | C1 |
| schema:position | 1 |
| schema:text | Conformance, 1 each. (a) PD-002 Customer (grain party, key party_id) and PD-022 Customer (grain card holder, key cardholder_id) are both marked conformed: same name, different grain and key. (b) Conformance judged by grain and key: PD-022 is not conformed - it is retired in favour of PD-002 (card holder mapped to party, a bridge for joint and additional cardholders) or renamed Cardholder and marked not conformed. (c) The consequence traced: DQ-1 'card spend and deposit balances by customer' joins card holders to parties by name, so for a joint account held by two customers the deposits and the card spend land on different 'customers' (or one customer's card spend is lost), and nothing errors. en |