\

Can someone please answer these questions. I rate if its the answer im looking for. Thank you in advance!

1. Consider the relation CLASS (Course#, Section#, Instructor Name, Semester, Building Code, Room, Time Period, Weekdays, Credit. Hours). This represents the classes taught in a university. List as many candidate keys as you can and state the assumptions under which each candidate key would be valid. 2. Consider the following six relations for an order-processing database application in a company: CUSTOMER (Cust#, 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. Specify all the foreign keys and the relations they refer to, respectively. 3. Consider the following relations for a database that keeps track of business trips of salespersons in a sales office. SALESPERSON (SSN, Name, Start. Year, Dept.Ne) TRIP (SSN, From City, Te City, Departure Date, Return Date, Trip. D) EXPENSE (Trip. ID, Account#, Amount) Specify all the foreign keys and the relations they refer to respectively