Break up the dependency diagram shown in Figure 1 to create two new dependency diagrams: one in 3NF and one in 2NF. Modify the dependency diagrams you created in part a to produce a set of dependency...

1. Break up the dependency diagram shown in Figure 1 to create two new dependency diagrams: one in 3NF and one in 2NF.


2. Modify the dependency diagrams you created in part a to produce a set of dependency diagrams that are in 3NF. (Hint:One of your dependency diagrams should be in 3NF but not in BCNF.)


3. Modify the dependency diagrams you created in Part b to produce a collection of dependency diagrams that are in 3NF and BCNF.

Please review the image