Normalize the following relational schema into at least Third Normal Form $(3$NF$)$ and show that all entities are in at least $3$NF$.$

Make a copy of the diagram Normalization$-$ERD $$ in LucidChart and then modify that copy $($use File$/$Duplicate in LucidChart $--$ do not ask for edit

copy the diagram.

You may collaborate and discuss this problem with up to two peers in private and you may post questions on the course forum but you may not

seek the assistance of anyone outside the course.

You must make an individual submission, i$.$e$.,$ you and your discussion partner cannot submit the same diagram.

Add additional entities $($tables$)$ as required.

Open the LucidChart diagram to see the glossary of terms on a separate page $($tab$).$

Resolve any many$-$to$-$many relationships.

Submission

Submit a PDF that contains the revised ERD $($in Crow's Foot Notation$)$ and your "proofs" of $3$NF compliance. You do not need to $($but should$)$ update

the glossary or sample tables. By "proof" we mean that you need to show that each table is in $3$NF by listing the functional dependencies and

explain that the list of FDs meet the requirements of $3$NF$.$