@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@prefix owl: <http://www.w3.org/2002/07/owl#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix schema: <https://schema.org/> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .

<https://knobit.org/id/task/dm-physical-postgres/C4> a edu:Question ;
    rdfs:label "C4 (2 points)"@en ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    owl:sameAs <https://bitbucket.org/reffa/ontology/id/task/dm-physical-postgres/C4> ;
    schema:hasPart <https://knobit.org/id/register/data-modelling#I-617> ;
    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 .

edu:Question rdfs:label "Question"@en,
        "Küsimus"@et .

<https://knobit.org/id/register/data-modelling#I-617> rdfs:label "dm-physical-postgres C4: savings rate history, email overwrite kept"@en .