cs 411-01 Database Management System Design Spring 2018 Test 3 7. (24 points) Consider the following six relations / tables for an ORDER-PROCESSING database application in a company: CUSTOMER (Cust#, Cname , City) ORDER (Order# , Odate, Cust#, Ord ORDER ITEM (Order# , Item# , Qty) ITEM (Item#, Unit-price) Amt) SHIPMENT (Order# , warehouse, ship-date) WAREHOUSE (Warehouse#, City) Here, Ord_Amt refers to total dollar amount of an order, Odate is the date the order was plac Ship_date is the date an order is shipped from the warehouse. Assume that an order can be shipped from several warehouses