I1 (1 points)
https://knobit.org/id/task/dm-physical-postgres/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-physical-postgres/I1 |
| rdfs:label | I1 (1 points) en |
| schema:hasPart | dm-physical-postgres I1: branch merged into account |
| schema:identifier | I1 |
| schema:position | 5 |
| schema:text | Tables merged: account carries branch_code, branch_name and branch_bic, so a new branch cannot be recorded before an account is opened there, a renamed branch must be updated on every account, and purging the last account loses the branch. A branch table becomes the system of record (keyed by branch_code, or a surrogate with a unique branch_code) with a foreign key from account; the name and BIC leave account (a view may join them back for the servicing screen). en |
Used by
| has question | Retail banking servicing schema on PostgreSQL (transactional physical design anomaly skills) |
|---|---|
| schema:isPartOf | dm-physical-postgres I1: branch merged into account |