Task 2.1

or this task we had to do two primary things:

- Convert data in a particular database (the "Groceries" database in this case) to 3NF
- Migrate the data from the old database into the new one

We found that most of the tables within the database were already pretty well formed. The main thing we had to do to achieve 3NF was remove a lot of redundancy within particular tables. See screenshots below:

Schema before modification

Click to see a bigger version of this image

Schema after modification

Click to see a bigger version of this image

Overall the first half of this task was relatively easy and did not take a great deal of time. In fact more time was spent remembering database skills than actually performing the modifications to the schema!

The second half of this task was significantly more difficult, and to this point, has not yet been accomplished. Migrating the data from the old database schema to the new and modified one has proved exceedingly difficult. Brett and I believe this to be due to the differences in the construction of each of the databases.