Question

1. (30 points: 15 each) INormalization: 4NFI 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 ProiName SUPPLY SUPPLIER N PROJECT SUPPLY Sname ProjName PartNo Quantity Date Parte PART 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.

Answer 1