C3 (2 points)

https://knobit.org/id/task/dm-logical-integrity/C3

dcterms:license	https://creativecommons.org/licenses/by/4.0/
owl:sameAs	https://bitbucket.org/reffa/ontology/id/task/dm-logical-integrity/C3
rdfs:label	C3 (2 points) en
schema:hasPart	dm-logical-integrity C3: lossy split of card issue on the role code
schema:identifier	C3
schema:position	3
schema:text	The v0.4 split of Card Issue into Card Account Role (card account, role) and Party Card Role (person, role), joined back on Card Role Code, is lossy: Card Role Code is a key of neither part, so two card accounts each with an additional card holder join back into four holdings. 1 for reporting it as a lossy decomposition with the shared non-key attribute named (an example spurious row, or the four-from-two arithmetic, is enough); 1 for the fix: the issue fact is kept whole, on Card (card number -> holder, role) or on a single Card Issue entity, and the two fragments are removed. en

Used by

has question	Retail banking servicing logical model (higher normal forms, decomposition and path anomaly skills)
schema:isPartOf	dm-logical-integrity C3: lossy split of card issue on the role code