411-01 Database Management System Design Test3 Spring 20 7. (24 points) Consider the following six relations /tables for an ORDER-PROCESSING database application in a company: CUSTOMER (Custtt, Cname, City) ORDER (Order#, odate, cust#, ord Amt) ORDER-ITEM (Order# , Item#, Qty) ITEM (Item# , Unit-price) 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 placed; Ship_date is the date an order is shipped from the warehouse. Assume that an order can be shipped from several warehouses. A. (6 points) Specify the primary keys (by underlining them above) B. (6 points) Specify foreign keys for this schema using the following notation: ORDER. Cust # CUSTOMER where Cust# is a foreign key in ORDER (it is by default that