DBMS Assign 2

Normalization Practice 1 BIS 638 – Database Management for Business Systems

The Acme Company maintains a list of the parts they order from their vendors along with the prices that each vendor charges. The following table shows a portion of this data: PartCost

PartNbr Desc VendorNbr VendorAddress UnitCost

1234 Processor 117 Cupertino, CA $10.00

1234 Processor 623 Phoenix, AZ $8.00

5678 Memory 117 Cupertino, CA $3.00

5678 Memory 305 Austin, TX $2.00

5678 Memory 623 Phoenix, AZ $5.00

Field Descriptions: PartNbr – number of the part in inventory Desc – text description of the part VendorNbr – number of the vendor who supplies the part VendorAddress – city and state where the vendor is located UnitCost – cost the vendor charges for the part 1. Use arrows to show the functional dependencies in the table. 2. Convert the table into 3NF relations.