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 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. Part No 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 Unit Cost 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
To solve the questions lets approach them step by step Question 1 Convert to First Normal Form 1NF T... View full answer
Get step-by-step solutions from verified subject matter experts
