3. Following table contains sample data for parts and for vendors who supply those parts. In discussing these data with users, we find that part numbers uniquely identify parts and that vendor names uniquely identify vendors. a. Convert this table to a relation (named PART SUPPLIER) in first normal form. Illustrate the relation with the sample data in the table. b. List the functional dependencies in PART SUPPLIER and identify a candidate key. c. For the relation PART SUPPLIER, identify each of the following: an insert anomaly, a delete anomaly, and a modification anomaly. d. Transform PART SUPPLIER into 2NF e. Transform PART SUPPLIER into 3NF Copyright 92013 Pearson Education, publishing as Prentice Hall