Database Management Systems 4850

Entity Relationship Diagram - ERD Design

Purchase Order ERD - Database Design

Design a database based on the enclosed Purchase Order and related data for New World Co. Please ensure that in your ERD, all the relations are in 3NF and the relationships are properly established, i.e., the database is fully integrated. All the required data should be stored in the database.

Assume that the firm has 4 delivery locations: warehouse 1, 2, 3, 4, and several vendors, parts, buyers, purchasing assistants, and of course orders. What you see is just a sample. Note how the format permits specification of multiple due dates for the same part in the last two lines. You can treat item numbers as simply line numbers on the document.

New World Company PURCHASE ORDER NW-01-16366 Floor 100 100 Main Street G.P.O. Bor 100, Globecity Globeland, T000 P.O. Date Resale No. SR AC 16-943236 TAN 2200l GSA Sale No TO: Acme Parts Corporation SHIP TO: The New World Company 1223 Kelon Street Globecity, Globeland 1000 (via FAX 999/999-9999) 2467 Pioneer Road Globecity, Globeland, 1000 Attn: Shipping/Mary Phone (999) 999-9999 Contact John Hancock FOB: Vendor/Globecity Globeland ITEM QUANTITY | PART NUMBER DESCRIPTION SHIP VIA: UPS TERMS: Net 30 days REQUIRED UM UNIT PRICE PRICE 295.00 285.00 180.00 500.00 120.00 300.00 400.00 250.00 DATE 0 F54740 15 F85352 6 F84352 20 L86355 12 L86362 40 A86357 25 A86362 50 A86552 00 A84352 00 A36352 NW Globe Chassis, 1492 Model NW Globe Light Kit NW Globe 30" Oak Stand NW Atlas Leather-Bound NW Atlas Young Readers Series NW Pen Rollerball NW Pen Fountain NW Globe Beach Balls, 24" NW Promotional Calendars NW Promotional Balloons 28/02/01 EA 28/02/01 EA 28/02/01 EA 28/02/01 EA 28/02/0 EA 28/02/01 EA 28/02/01 EA 28/02/01 EA 28/02/0 EA 28/02/01 EA 29.50 002 003 004 005 006 30.00 25.00 10.00 16.00 008 009 ell 2DD A36352 NwProvofona Ballon 3c/04/01 EA o.IS 30.OD 1.PURCHASE ORDER NUMBER, PART NUMBER AND QUANTITY MUST SHOW ON EACH CARTON 2. Two packing sheets must accompany each shipment. SUB-TOTAL | 2,355.00 41.50 TOTAL2,496.50 1(up 3. Proteotion of Material in Transit. All articles delivered on this order to be packed adequately to prevent any newsprint and glassine begs prohibited. All packages to be must execute acknowledgment copy hereot and return to buyer. No other form of accoptances on buyer, whether or not they would materially alter this order damage In shipment and storage. Use of TAX dentified NW-01-16356 binding on buyer. Buyer expreasly limits acceptance to the terms slated herein and any additional or difterent erme proposed by seler shall not be binding and are rejected ANY BOX OVER SO KILOS WILL BE REFUSED P.O. ACKNOWLEDGED BY JA OATE:/28/2001 NAME: BUYER Page: 1 of PurphaseOraler.ctp6-Sep004 DATE