I1 (2 points)
https://knobit.org/id/task/dm-reverse-engineering/I1
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-reverse-engineering/I1 |
| rdfs:label | I1 (2 points) en |
| schema:hasPart | dm-reverse-engineering I1: entities, associative entity and keys recovered |
| schema:identifier | I1 |
| schema:position | 7 |
| schema:text | Part B recovers the account schema's logical structure, 1 each: (a) the entities are Customer, Account, an associative Account Holding (or similar) between them carrying the role and the from date, and Account Transaction - the customer-to-account many-to-many is resolved, not lost; (b) the keys are recovered: the declared primary keys of CUST, ACCT and ACCT_TXN, the IBAN as the account's natural key from its unique constraint, and the holding's key from the unique index on (ACCT_ID, CUST_ID, ROLE_CD). en |
Used by
| has question | Reverse engineering a banking schema, reviewed and done (reverse engineering skills) |
|---|---|
| schema:isPartOf | dm-reverse-engineering I1: entities, associative entity and keys recovered |