C1 (2 points)
https://knobit.org/id/task/dm-logical-integrity/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/dm-logical-integrity/C1 |
| rdfs:label | C1 (2 points) en |
| schema:hasPart | dm-logical-integrity C1: advisor determinant that is not a key (BCNF) |
| schema:identifier | C1 |
| schema:position | 1 |
| schema:text | Customer Advisor Assignment is keyed on (customer, advice area) while BR-111 makes the advisor determine the advice area: a determinant that is not a candidate key, hidden behind the overlapping candidate keys (customer, advice area) and (customer, advisor). 1 for reporting it as a BCNF violation with that dependency named; 1 for the fix: the advice area moves to Advisor and the assignment is keyed on customer and advisor (or the entity stays in 3NF with a waiver naming the accepted update anomaly). Calling it a partial or transitive dependency earns the first point only if the dependency Advisor -> Advice Area is stated. en |
Used by
| has question | Retail banking servicing logical model (higher normal forms, decomposition and path anomaly skills) |
|---|---|
| schema:isPartOf | dm-logical-integrity C1: advisor determinant that is not a key (BCNF) |