Database

Initially I created a good database that tried to be as compatible as possible with the old one, but unfortunately it was impossible to import the data from the old database to the new one, due to numerous key restrictions and different attribute types.
I then created a 2nd database that discarded the data from the original database, and assumed the data was going to be manually input afterwards. After discussing with the client it was decided to try to import the data again.
After several hours of error correction, foreign key constraints, and overall feeling of dread, I was finally able to import the data, table by table, and auto generate a script that would be able to import that data into a 3rd database.
I then coded the 3rd database and imported the information to it. Below is a screenshot of the database creation script, and another for the data import script.