Question: Use the dependency diagram shown in Figure P6.8 to work the following problems.
a. Break up the dependency diagram shown in Figure P6.8 to create two new dependency diagrams: one in 3NF and one in 2NF.
b. Modify the dependency diagrams you created in Problem 8a to produce a set of dependency diagrams that are in 3NF. (One of your dependency diagrams should be in 3NF but not in BCNF.)
c. Modify the dependency diagrams you created in Problem 8b to produce a collection of dependency diagrams that are in 3NF and BCNF.
