Question: Table 3 ( E , A , B , C 1 , D 1 , C 2 , D 2 , C 3 , D
TableE A B CDCDCD
Note that the following table as is can have from up to 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 NF 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 unnormalizedNFNFNF and what properties exist that prevent it from being in NF 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 tables in NF
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
