2. (10 marks) Design a simple database with at least 5 relations for such applications as "students taking courses taught by faculty in class rooms at a specific time", "customers ordering items at specific dates and ordered items shipped from warehouse at a specific date". a. Specify all the foreign keys in your designed database. State each foreign key using the following format "foreign key is the attribute ---------- of relation --------- that references relation (5 marks) 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) Foreign Key Question 2a (5 marks) of relation --------------- that references i. foreign key is the attribute ------------- relation of relation --------------- that references ii. foreign key is the attribute --------------- relation --- iii. foreign key is the attribute --------------- relation -------- of relation --------------- that references iv. foreign key is the attribute --------------- of relation --------------- that references relation -- v. foreign key is the attribute --------------- relation -- of relation --------------- that references Question Query Tables needed to answer query 2b (5 marks) i. 2. (10 marks) Design a simple database with at least 5 relations for such applications as "students taking courses taught by faculty in class rooms at a specific time", "customers ordering items at specific dates and ordered items shipped from warehouse at a specific date". a. Specify all the foreign keys in your designed database. State each foreign key using the following format "foreign key is the attribute ---------- of relation --------- that references relation (5 marks) 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) Foreign Key Question 2a (5 marks) of relation --------------- that references i. foreign key is the attribute ------------- relation of relation --------------- that references ii. foreign key is the attribute --------------- relation --- iii. foreign key is the attribute --------------- relation -------- of relation --------------- that references iv. foreign key is the attribute --------------- of relation --------------- that references relation -- v. foreign key is the attribute --------------- relation -- of relation --------------- that references Question Query Tables needed to answer query 2b