Below is a sample data for Parts and for Vendors who supply those parts. In discussing these data with users, we find that part numbers (but not description) uniquely identify parts and that vendor names uniquely identify vendors. Part_No Description Vendor_Name Address Unit_Cost 1234 Logic Chip Fast Chips Kumasi 10.00 Smart Chips Accra 8.00 5678 Memory Chip Fast Chips Kumasi 3.00 Quality Chips Obuasi 2.00 Smart Chips Accra 5.00 b) List the functional dependencies in PARTSUPPLIER and identify a candidate key. c) Develop a set of 3NF relations from PART SUP
Below
is a sample data for Parts and for Vendors who supply those parts. In
discussing these data with users, we find that part numbers (but not description)
uniquely identify parts and that vendor names uniquely identify vendors.
Part_No Description Vendor_Name Address Unit_Cost
1234 Logic Chip Fast Chips Kumasi 10.00
Smart Chips Accra 8.00
5678 Memory Chip Fast Chips Kumasi 3.00
Quality Chips Obuasi 2.00
Smart Chips Accra 5.00
b) List the functional dependencies in PARTSUPPLIER and identify a
candidate key.
c) Develop a set of 3NF relations from PART SUPPLIER
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images