PLEASE HEELLLP ME AS SOON AS POSSIBLE DUE IN 2 WEEKS. THANK YOU!!

Project Module 3 (40 marks) Consider the following relations Patients(pid, name, address, telephone, care_centre_id) Care_centres(cid, name, location, nurse_charge_id) Treatments(tid, patient_id, physician_id, treatment_name, date) Nurses(nid, name, care_centre_id, certificate_type, telephone, salary) Physicians(phid, name, pager_number, specialization, salary). Use Oracle to complete the following tasks. Create the tables that correspond to these relations in your Oracle home database. (6 marks) If not automatically created by the DBMS, create indexes corresponding to the primary and foreign keys. (6 marks) Populate these tables with some sample data, and write SQL queries that show the content of each table after entering the data. (6 marks) For some strategic decisions, the president of the hospital needs summary data about the care centres. For each care centre, s/he needs to know the number of nurses holding an RN certificate, as well as their total and average salaries. Does the following view answer the president's request? If not, write the correct view that will satisfy the president's request. (7 marks) a. b. c. d. CREATE VIEW NURSE SUMMARY (D, C, TOTAL_S, AVERAGE S) AS SELECT cid, COUNT ("), SUM (salary), AVG (salary) FROM Care_centres, Nurses WHERE nurse_charge_id nid and certificate_type like 'RN' GROUP BY cid