$(2$pts$)$ Normalize the table to $2$NF by resolving the partial dependencies listed above.

Give meaningful names to all new tables.

b$.(2$pts$)$ Normalize the database to $3$NF by resolving the transitive dependencies listed above.

c$.(2$pts$)$ Normalize the database to Boyce$-$Codd Normal Form $($BCNF$)$ by resolving the backwards

dependency listed above.

d$.(2$pts$)$ Draw a crow$$s foot ERD of the fully normalized database, indicating all entities and

relationships. $($For simplicity, you may assume all participation is mandatory.$)$

e$.(2$pts$)$ Identify at least one problem in the final design, and explain what you might do after

normalization to address that problem.