C2 (2 points)
https://knobit.org/id/task/dm-physical-postgres/C2
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/C2 |
| rdfs:label | C2 (2 points) en |
| schema:hasPart | dm-physical-postgres C2: soft-deleted customers and the constraints |
| schema:identifier | C2 |
| schema:position | 2 |
| schema:text | Soft delete the constraints do not understand, 1 each: (a) uk_person_customer_pic (and uk_org_registry_code) count soft-deleted rows, so a person whose record was deleted cannot be registered again (BR-303); replaced by uniqueness over active rows only, a partial unique index WHERE NOT is_deleted, which PostgreSQL has, or by moving deleted rows to a history table. Dropping uniqueness altogether scores 0; (b) something stops active rows referencing a deleted customer (BR-303): a rule enforced by the delete procedure or a trigger, a DQ rule on account_holder, or views exposing only active customers that the application uses, stated as such. en |
Used by
| has question | Retail banking servicing schema on PostgreSQL (transactional physical design anomaly skills) |
|---|---|
| schema:isPartOf | dm-physical-postgres C2: soft-deleted customers and the constraints |