I2 (1 points)
https://knobit.org/id/task/dm-physical-postgres/I2
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/I2 |
| rdfs:label | I2 (1 points) en |
| schema:hasPart | dm-physical-postgres I2: overdraft terms split without an enforced one-to-one |
| schema:identifier | I2 |
| schema:position | 6 |
| schema:text | Unconstrained vertical split: account_overdraft_terms has its own surrogate and a non-unique account_id, so one account can get two sets of overdraft terms, which BR-310 forbids. Fixed by keying the extension on account_id (primary key and foreign key at once), or by a unique constraint on account_id; whether the extension is optional (an account without an overdraft has no row) is stated. en |
Used by
| has question | Retail banking servicing schema on PostgreSQL (transactional physical design anomaly skills) |
|---|---|
| schema:isPartOf | dm-physical-postgres I2: overdraft terms split without an enforced one-to-one |