>example a persons table:
>
>Personid, firstname, lastname, adress, postalcode, city, dayofbirth, function, department, etc.
>
>when you want to track changes you would probabply add a date identifyier to mark from which data this data becomes current:
>
>(SomePk,) Date, Personid, firstname, lastname, adress, postalcode, city, dayofbirth, function, department, etc.
>
>If this person changes departments the attributes are copied into a new record
>with a new datestamp. Though the department has changed, it still contains the
>same values for the other attributes. Is this redundant data ? if so, how
>would you solve this ?
You have a person table, a department tables, and a person/department table which has the person key, department key, and date they started working there.