C4 (2 points)
https://knobit.org/id/task/dm-logical-integrity/C4
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/dm-logical-integrity/C4 |
| rdfs:label | C4 (2 points) en |
| schema:hasPart | dm-logical-integrity C4: broker join dependency decomposed, signatory authority kept whole |
| schema:identifier | C4 |
| schema:position | 4 |
| schema:text | Join dependency, both directions, 1 each: (a) Broker Product Region is kept as one three-way entity although BR-107 is the cyclic rule that makes it the join of its three projections; it is replaced by Broker Product Accreditation, Broker Region Licence and Loan Product Region Offer, with the cyclic rule recorded as a data rule (the three-way fact derived, not stored); (b) Account Signatory Authority is left as one three-way entity, because BR-131 grants each (account, signatory, payment type) combination on its own and no cyclic rule holds. Splitting Account Signatory Authority into pairs scores 0 for (b). en |