Consider the table below which 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.
|Parts Supply List|
|Part #||Description||Vendor name||Address||Unit cost|
|1234||Logic chip||Fast Chips||Cupertino||10.00|
|5678||Memory chip||Fast Chips||Cupertino||3.00|
- Perform all the steps of the normalization process in order to get this relation into 1NF. What is the primary key of this relation? Draw the determinancy diagram.
- How many primary keys are there?
- How many fields are there in the primary key(s)?
- Put the this information into 3NF. State any assumptions you have to make.