Given the information in Table P$6\mathrm{.}9$:

a$.$ Draw the dependency diagram.

b$.$ Identify the multivalued dependencies.

c$.$ Create the dependency diagrams to yield a set of table structures in $3NF.$

d$.$ Eliminate the multivalued dependencies by converting the affected table structures to $4$NF$.$

e$.$ Draw the Crow's Foot ERD to reflect the dependency diagrams. $($Note: You might have to

create additional attributes to define the proper PKs and FKs$.$ Make sure that all of your

attributes conform to the naming conventions.$)$