I have recently inherited a database that was designed several years ago (at least 8 yrs) by someone who thought they knew about relational databases. My job is to normalize the database. The problem is that the database has over 8 years of data! I have the new database designed, but I am having trouble fitting the old database records into the new structure!

The original database had 3 main tables and a few look-up tables. The new structure will separate the 3 existing tables into 8 tables and each table will have several look-up tables.

Can anybody give me some advice as to how to go about this?