Wednesday, August 25, 2010

Task 2.2

The objective of this task is to provide and describe my completed schema design.

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.

No comments:

Post a Comment