Question: 1(30 points: 15 each) [Normalization: 4NFI Consider the relation SUPPLY below (right). mapped from the ternary relationship SUPPLY in the ER diagram below (left), and

 1(30 points: 15 each) [Normalization: 4NFI Consider the relation SUPPLY below(right). mapped from the ternary relationship SUPPLY in the ER diagram below

1(30 points: 15 each) [Normalization: 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( Date) ProlName SUPPLY SUPPLIER SUPPLY PROJECT Sname ProjName PartNo Quantity Date PartNo 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!