$*$ Remove all partial dependencies, and draw the new dependency diagrams. Identify the normal forms for each table structure you created. Remove all transitive dependencies, write the relational schema, and draw the new dependency diagrams. Also identify the normal forms for each table structure you created.

$*$ Draw the Crow's Foot ERD. ERD should be created starting from solution of part b $($normalized form$)$ and then further enhanced to reflect the correct business scenario.