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...

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