Date: 08/07/06 (MySQL Communtiy)    Keywords: database

I'm developing a database of organisations with all the familiar field names that you would expect e.g., name of organisation, various address fields, office bearer fields etc.

However I also want to have a "Year" field, so I can lookup information about the organisation in 2002, 2003, 2004, 2005 etc as the organisations I'm keeping track of have a high turnover of office bearers and, of course, occassionally address (and a couple have even changed their name).

One method would be have a table for each year for each organisation, but that offends my sense of optimisation and normalisation.

Any suggestions?

Source: http://community.livejournal.com/mysql/101012.html