What is the best database design for managing historical information? [closed]
- by Emmad Kareem
Say you have a Person table with columns such as:
ID, FirstName, LastName, BirthCountry, ...etc.
And you want to keep track of changes on such a table. For example, the user may want to see previous names of a person or previous addresses, etc.
The normalized way is to keep names in separate table, addresses in a separate table,...etc. and the…