NORMALIZATION

1A) Break up the dependency diagram above to create 2 new dependency diagrams, one in 3 NORMAL FORM and one in 2 NORMAL FORM.

2A)Modify the dependency diagrams you produced in 1A to produce a set of dependency diagrams that are all in 3 NORMAL FORM. To keep the entire collection of attributes together, copy the 3 NORMAL FORM dependency diagram from 1A and then show the new dependency diagrams that are also in 3NF. (Hint: One of your dependency diagrams will be in 3NF, but not in BCNF)

Normalization [2596] 1 Break up the dependency diagram above to create 2 new dependency diagrams, one in 3NF and one in 2NF. 2 Modify the dependency diagrams you produced in 3.1 to produce a set of dependency diagrams that are all in 3NF. To keep the entire collection of attributes together, copy the 3NF dependency diagram from 1.1 and then show the new dependency diagrams that are also in 3NF. (Hint: One of your dependency diagrams will be in 3NF, but not in BCNF)