C4 (2 points)
https://knobit.org/id/task/dm-physical-postgres/C4
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/C4 |
| rdfs:label | C4 (2 points) en |
| schema:hasPart | dm-physical-postgres C4: savings rate history, email overwrite kept |
| schema:identifier | C4 |
| schema:position | 4 |
| schema:text | Overwrite where history is required, both directions, 1 each: (a) account.savings_interest_rate is updated in place although BR-304 needs the rate as at any past date; updated_at records only the last change. Replaced by a history strategy chosen from BR-304 and recorded in the table comment: an effective-dated rate table or a history table, with its validity convention stated and overlap prevented (an exclusion constraint, or a DQ rule); (b) person_customer.email_address stays overwritten in place, because BR-305 says no history is needed. Adding history for the email address scores 0 for (b). en |
Used by
| has question | Retail banking servicing schema on PostgreSQL (transactional physical design anomaly skills) |
|---|---|
| schema:isPartOf | dm-physical-postgres C4: savings rate history, email overwrite kept |