6. Given the dependency diagram shown in Figure Q6.6, answer Items 6a-6c. a. Identify and discuss…

6. Given the dependency diagram shown in Figure Q6.6, answer Items 6a-6c.

a. Identify and discuss each of the indicated dependencies.

b. Create a database whose tables are at least in 2NF, showing the dependency dia- grams for each table.

c. Create a database whose tables are at least in 3NF, showing the dependency dia- grams for each table.