A.) Show all functional dependencies and multivalued dependencies applied to the attributes in the SUPPLY relation. Use box notations like Figure 14.13 (note: single arrow head for functional dependency and double arrowhead for multivalued dependency). In addition, underline the primary key of the SUPPLY relation.

B.) State if the relation SUPPLY is in BCNF and justify your answer. In addition, state if the relation SUPPLY is in the fourth normal form (4NF) as well and justify your answer.

1. (30 points: 15 each) [Normalization: 4NF] Consider the relation SUPPLY below (right), mapped from the ternary relationship SUPPLY in the ER diagram below (left), and answer the questions below Sname Quantity DatePrName SUPPLY Sname ProjName PartNo Quantity Date PartNo PART