$3)$ Are there any partial dependencies in Table P$6\mathrm{.}6?($YES or NO$)$ If "YES", list those

dependencies and explain why they match the definition of a partial dependency.

$4)$ Are there any transitive dependencies in Table P$6\mathrm{.}6?($YES or NO$)$ If "YES", list

those dependencies and explain why they match the definition of a transitive

dependency.

$5)$ Using the insights developed by responding to questions $(1)$ to $(4)$ above, convert

Table P$6\mathrm{.}6$ into a set of database tables that are in $3$NF$.$ Make sure no partial or

transitive dependencies end up in the result. Document this new database design as

an ER diagram in the style presented in Module $3,$ drawn using draw.io$.$ Specify a

primary key $($PK$)$ for each table. Include all relationships $($foreign keys $/$ FKs$).$ Your

ERD should not include any "many$-$to$-$many" relationships; if you have any, they

should be converted into associative entities and "one$-$to$-$many" relationships. Once

your diagram is complete, export it as a $.$png file, which you can then insert into your

submission document for this assignment.

$6)$ List all functional dependencies for each table $($entity$)$ in your question $(5)$ response.