Create an ER-Diagram in which the relations are in 3NF and the relationships are properly established, i.e., the database is fully integrated. Assume that the firm has 4 delivery locations: warehouse 1, 2, 3, 4, and several vendors, parts, buyers, purchasing staff, and of course orders. What you see is just a sample.

New World Company PURCHASE ORDER Number NW-01-16366 P.O. Date Resale No. SR AC 16-943236 GSA Sale No TO: Acme Parts Corporation SHIP TO: The New World Company 2467 Pioneer Road Globecity, Globeland, 1000 Attn: ShippingMary Phone (999) 999-9999 Contact John Hancock 1223 Kelon Stroet Globeland 1000 (via FAX 999 999-9999) FOB: Vendor/Globecity Globeland SHIP VIA: UPS TERMS: Net 30 days REQUIRED w ITEM 001 002 003 004 005 006 007 008 009 010 QUANTITY|PART NUMBER 10 F54748 15 F85352 6 F84352 20 L86355 12 L86362 40 AB6357 25 A86362 50 A86552 100 AB4352 100 A36352 |DESCRIPTION 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 Baloons UNIT PRICE 29.50 19.00 30.00 25.00 10.00 7.50 16.00 PRICE 295.00 285.00 180.00 500.00 120.00 300.00 400.00 250.00 10.00 15.00 DATE 28/02/01 EA 28/02/01 EA 2802/01 EA 28/02/01 EA 28/0201 EA 202/01 EA 2802/01 EA 28/02/01 EA 2802/01 EA 28 02/01 EA OROER NUMBER, PART NMBER AND QUANTITY MUST SHOW ON EACH CARTON SUB-TOTAL! 2,355.00(up a. Two packing sheets must sccompany each shipment 3 Proloction of Material In TransiL Al de auticles delivored on this order lo be packod adequetely to prevent any damage in shioment and storage Use of nowsprint and gjassine begs pioited All packages to be copy hareo and roturn to buyer. No other form of acceptance is Liimlhg on buyar, euyer expreasly limts acceptanco to the terms staled heroin and any additional or difterant ceilor shell nos bo binding an buyer, whother or not they would matorialy aller this arder TAX 141.50 4.Seller must easeute ackncwiedgment TOTAL2 2,496.50 and are rejocted . ANY BoxX OVER S0 KILOS WILL BE REFUSED. P.O, ACKNOWLEDGED BY: BUYER DATE DATE Page: 1 of 1