The objective of this task is to discuss the nature of my team.
My task team is supposed to be made up of three members, myself, Brett and some other guy that never comes. So as of now he's no longer in our group. I think we have a good team because Brett and I get along rather well. We understand that by working cooperatively we can achieve more and decisions are made in this fashion. Performing the group tasks usually takes place within the studio sessions in the form of a discussion. At this point communication only takes place within the studio sessions, but as more coordination is required to perform the group tasks I believe this will change.
Wednesday, August 25, 2010
Task 2.2
The objective of this task is to provide and describe my completed schema design.
My modified database schema essentially reproduces the original database in a simplified relational format. Many-to-many relationships have been removed and replaced with join tables, the unnecessary duplicate columns (there were so many of these) have been removed. Overall I think the modified database represents a significant improvement over the original.
Modified schema
Click to see a bigger version of this image
My modified database schema essentially reproduces the original database in a simplified relational format. Many-to-many relationships have been removed and replaced with join tables, the unnecessary duplicate columns (there were so many of these) have been removed. Overall I think the modified database represents a significant improvement over the original.
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:
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.
- 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.
Subscribe to:
Comments (Atom)