title: Having issue designing database for such cases
body: <p>I have a employee table and in this we store his employee id and project and account name to which he belongs. When he changes his account after few months, it is becoming to track him in both accounts as we modify the account name in his record. 
  How do we handle such situations. </p>