Question: Question 2 (11 points) The following table contains sample date for parts and for vendors who supply those parts. In discussing these data with users,

 Question 2 (11 points) The following table contains sample date for

Question 2 (11 points) The following table contains sample date 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 vendor names uniquely identify vendors. PartNo 1234 1234 5678 5678 5678 Description Logic Chip Logic Chip Memory Chip Memory Chip Memory Chip VendorName Fast Chips Smart Chips Fast Chips Quality Chips Smart Chips Address Cupertino Phoenix Cupertino Austin Phoenix UnitCost 10.00 8.00 3.00 2.00 5.00 Question 1 (2 points): Convert this Table to relation (named PART SUPPLIER) in first normal form. Please use the relation schema such as: COURSE (CourseNo, CourseName) Question 2 (3 points): List the functional dependencies in PART SUPPLIER and identify a candidate key. Question c (6 points): Develop a set of 3NF relations from PART SUPPLIER

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!