DBMS Assign 2

Normalization Practice 2 BIS 638 – Database Management for Business Systems

The following table shows a partial list of orders from an organization’s order management system:

OrderInfo

OrderNbr OrderDate ItemNbr ItemDesc UnitPrice OrderQty ShipperNbr ShipperName ShipperPhone

100 09/02/10 111 Widget $25 32 300 UPS 989-674-0223

100 09/02/10 333 Super Widget $70 51 300 UPS 989-674-0223

101 09/03/10 333 Super Widget $70 47 100 DHL 989-543-9878

102 09/03/10 222 Widget Plus $45 54 200 Fedex 989-322-5541

102 09/03/10 444 Mega Widget $115 34 200 Fedex 989-322-5541

103 09/04/10 111 Widget $25 41 300 UPS 989-674-0223

103 09/04/10 333 Super Widget $70 15 300 UPS 989-674-0223

103 09/04/10 444 Mega Widget $115 77 300 UPS 989-674-0223

Field Descriptions: OrderNbr – number of the order OrderDate – date that the order was received ItemNbr – number of the item on the order (orders can have many items) ItemDesc – text description of the item UnitPrice – price charged for one item OrderQty – number of items ordered ShipperNbr – number of the shipping company ShipperName – name of the shipping company ShipperPhone – contact phone number for the shipping company 1. Use arrows to show the functional dependencies in the table. 2. Convert the table into 3NF relations.