Servus Gnana,

have a look at this book:
Data Modeling Essentials : Analysis, Design, and Innovation
(Vnr Computer Library) by Graeme C. Simsion
it has one chapter about the time dimension in an
ERM Model.

History is not easy to modell, the solution depends
heavy on your data and data model, a time stamp is
sometimes a too simple solution.

Another approach for modeling the time dimension is
the fact and dimension tables from the dimensional
modeling used in data warehouseing. Very good for
(ad-hoc) queries, not very easy to update.




>Hi
>
>I am designing and implementing a database using VFP 6.0. I am having to move the data from the working database to the history from time to time. I was wondering if there is any standard methodology in getting this accomplished. I would appreciate it if some would briefly explain the strategy of doing it or point me to some books/documentation I can gather this info from.
>
>Thanks
>Gnana