Convert this table to a relation (named PART SUPPLIES) in first normal form. You just need to write the relation schema. 12 points) b. illustrate the relation with the sample data in the table. (1.5 points cust the functional dependencies in PART SUPPLIER 3 points] d. For the relation PART SUPPLIER, Identity each of the following: 11.Spoints) An insert anomaly A delete anomaly A modification anomaly e Draw a relational schema for PART SUPPLIER and show the functional dependencies. (4 points) In what normal form is this relation? Justify your answer. [1 point) 8. Develop a set of 3NF relations from PART SUPPLIER. (3 points) 1. Constraints between two sets of attribule of Domain of attributes e Set of candidate keys in a relation The mapping of two relations Part III: ANALYTICAL QUESTIONS (16 points The table below contains sample data for parts and for vendors who supply those parts. In discussing these data with users, we find that part numbers (but not descriptions) uniquely identity parts and that vendor names uniquely identity vendors. Part No Vendor Name Address Unit Cost Description Logic Chip 1234 Fast Chips Cupertino 10.00 Smart Chips Phoenix 8.00 5678 Memory Chip Fast Chips Cupertino 3.00 Quality Chips Austin 2.00 Smart Chips Phoenix 5.00 S 5 Convert this table to a relation (named PART SUPPLIES) in first normal form. You just need to write the relation schema. 12 points) b. illustrate the relation with the sample data in the table. (1.5 points cust the functional dependencies in PART SUPPLIER 3 points] d. For the relation PART SUPPLIER, Identity each of the following: 11.Spoints) An insert anomaly A delete anomaly A modification anomaly e Draw a relational schema for PART SUPPLIER and show the functional dependencies. (4 points) In what normal form is this relation? Justify your answer. [1 point) 8. Develop a set of 3NF relations from PART SUPPLIER. (3 points) 1