2. (10 marka) Given the following six relations for an order processing database application in a company: CUSTOMER (Cus Caama City) ORDER (Orderd. Odata Cust. Ordet) ORDER ITEM (Order. Item, Qty ITEM (Am Urbis) SHIPMENT (Order Warehouses, Shichdate) WAREHOUSE (Warehoud City) Here, Orde. Ant refers to total dollar amount of an order; Odate is the date the order was placed Shin date is the date an order (or part of an order) is shipped from the warehouse. Assume that an order can be shipped from several warehouses. Hint: Remember, the relations (tables) describing entities carry the primary keys that are referenced by the relations (tables) describing relationships between entities 2. Specify all the foreign keys for this schema. State each foreign key using the following fomat "foreign key is the attribute ---------- of relation -------- that references relation (5 marle) b. State two queries involving more than one table that can be posed on this database indicating the tables to visit to answer the queries each time. (5 marks) Question 2a (5 marks) Foreign Key i. the attribute Cust# of relation Order that references relation Camer, ii. the attribute Order of relation ORDER_ITEM that references relation ORDER. iii. the attribute Item# of relation ORDER_ITEM-that references relation ITEM, iv. the attribute SHIPMENT of relation SHIPMENT that references relation ORDER, and V. the attribute Warehouse# of relation SHIPMENT that references relation WAREHOUSE Question Query Tables needed to answer query 2b