Given the dependency diagram shown in Figure Q6.6, answer items

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

Given the dependency diagram shown in Figure Q6.6, answer items


a. Identify and discuss each of the indicated dependencies.
b. Create a database whose tables are at least in 2NF, showing the dependency diagrams for each table.
c. Create a database whose tables are at least in 3NF, showing the dependency diagrams for eachtable.