The 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 (but not descriptions) uniquely identify parts and that vendor names uniquely identify vendors. The Unit Cost represents the cost of a specific part for a specific vendor. TABLE 4-3 Sample Data for Parts and Vendors Address Part No 1234 Description Logic chip Unit Cost 10.00 8.00 Vendor Name Fast Chips Smart Chips Fast Chips Quality Chips Smart Chips 5678 Memory chip Cupertino Phoenix Cupertino Austin Phoenix 3.00 2.00 5.00 a. Complete this table so it can be considered a relation. Which attribute can be used as primary keys ? b. For the relation in a., identify each of the following: an insert anomaly, a delete anomaly, and a modification anomaly. c. Draw a 1NF relational schema (named PART SUPPLIER) and show the functional dependencies. d. Convert the 1NF in c. into a 2NF and show the functional dependencies. e. Convert the 2NF in d. into a 3NF and show the functional dependencies