2. (15 marks) CUSTOMER cid name 1111 John Smith 2222 Mary Pert address Windsor Windsor numorder 100 50 CHEF chid 1 2 chname Mana Patel Pat Goodman specialization celebrity fish address Windsor London MEAL mealid 23567 55555 meal name Chicken rice Fish potato Cost 20.45 30.50 SERVES chid 1 2 cid 1111 2222 mealid 23567 55555 mdate 10-Jan-21 20-Aug-20 a Write the SQL DDL instructions to create all 4 tables of the above database in the Oracle DBMS on our cs server specifying all constraints such as Key, entity and foreign key constraints as usual within each instruction (not separately). (6 marks) b. Using only the data in the above instance (not a new instance formed by you), write the SQL instructions to load insert) all the data above in the 4 tables you created. (5 marks) c. Write the SQL query for the following query posed on this database, also write the results of the query and the tables involved in answering the query. (6 marks) Print all meals names and date they are ordered (meal name, mdate) for customer named "Mary Pert (5 marks) Que 2a (5 marks.): Creating Tables Que 2b (5 marks): Inserting Data into the Database Tables Solution (6) Question Query Tables needed to answer query and Result 2c (5 marks) Tables needed are: Result of Query is