The following is an unnormalized PURCHASE ORDER table (created from the Purchase Order Form):

PURCHASE ORDER (PurchaseOrderNumber, PurchaseOrderDate, ExpectedShipDate, VendorNumber, VendorName, VendorAddress, VendorCity, VendorState, VendorZip, VendorTelephone, ItemNumber, Description, Quantity, Price)

The Business Rules are:

• Each purchase order has an unique number.
• Each purchase order is placed to one and only one vendor.
• Each vendor is identified by an unique number.
• A purchase order can have many different items ordered.
• Each item has an unique number.
• Prices for a specific item can vary from vendor to vendor.

Using the conceptual data model format (a list of table names ALL in CAPS followed by a list of fields between parentheses, identifying the primary key by underlying and bolding the fields, and identifying the foreign keys by italicizing the fields in question), create your normalized data model using Microsoft Word and submit your file as deliverable.

Purchase Order Purchase Order Number 100008 Purchase Order Date Expected Ship Date 1/31/2001 2/4/2001 Vendor Number Vendor Name Vendor Address Vendor City Vendor State Vendor Zip Code Vendor Telephone 1001 Square P Corporation 14532 Electron Way Middletown OH 45061-2079 (513) 688-2795 Item Number Description 7240v 40a 11 F 240v 100a solderless 13 M 120v 40a clip Quantity - Price 100 $12.56 500 $2.26 100 $1.87 Record: 1 of 3 > No Filter Search Record: 1 of 12 No Filter Search Purchase Order Purchase Order Number 100008 Purchase Order Date Expected Ship Date 1/31/2001 2/4/2001 Vendor Number Vendor Name Vendor Address Vendor City Vendor State Vendor Zip Code Vendor Telephone 1001 Square P Corporation 14532 Electron Way Middletown OH 45061-2079 (513) 688-2795 Item Number Description 7240v 40a 11 F 240v 100a solderless 13 M 120v 40a clip Quantity - Price 100 $12.56 500 $2.26 100 $1.87 Record: 1 of 3 > No Filter Search Record: 1 of 12 No Filter Search