Use the dependency diagram shown in Figure 6.8 to work the following problems.

a. Break up the dependency diagram in Figure 6.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 collection of dependency diagrams that are all in 3NF.
c. Modify the dependency diagrams in Problem 8b to produce a collection of dependency diagrams that are all in 3NF and BCNF.

Transcribed Image Text:

A BC D