Question: Table 3 ( E , A , B , C 1 , D 1 , C 2 , D 2 , C 3 , D

Table3(E, A, B, C1,D1,C2,D2,C3,D3)
Note that the following table as is can have from 1 up to 3 matched pairs of C and D values (multiples... grouped together... hmmm...), and many times, some of the pairs are NULL. There is a need to restructure to obtain 1NF. The only dependency is based on the key, E, and C doesnot determine D. In other words, each value of E determines one or more values of C, and one or more values of D.
a. Identify the normal form of the table (unnormalized,1NF,2NF,3NF) and what properties exist that prevent it from being in 3NF (multiply occurring groups, partial dependencies, transitive dependencies).
b. Perform the necessary changes to remove the properties identified in a, identifying each step taken. Provide the final table(s) in 3NF.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!