Dear students Below are the instructions for the practical test. Please read it carefully before preceding to the questions. 1. You have almost 24 hours to complete the practical test. 2. You have to submit the code and screenshots of the result via Blackboard link before the deadline. 3. The deadline is 07-05-2020 at 11:59 PM. Consider the following ERD for a Dental Clinic and solve the following questions. Dentist Appointment arch25) Voce Garrett GE uchar Details Patient Procedure contains patum.chart patamarchar25 arch25 chard pro Num.char t desorption varchar 2001 cost decima ) Section A: DDL and Relational Algebra (7marks) 1. Create the database by using SQL DDL commands and fill the tables with at least 3 rows. (5marks) 2. Code solutions to the following problems as a relational- algebraic expression: (2marks) a. Display all patients' names who have an appointment on 1-1-2020 b. Find dentists number and name who have 10 years of service and living in Muscat. Section B: DML (5marks) 1. Code the following problems in SQL commands: (2marks) a. Display all patients whose last name starts with Ali. b. Display the dentist name, grade, nurse name, grade, patient name, age, who live in Muscat. 2. Write the SQL code to change the address to Suhar for the patient whose patient number is 111. After you have completed the task, examine the results, and then reset the address to its original value. (3marks) Section C: PL/SQL (8marks) 1. Write a procedure called patient_delete_procedure to delete the patient 'ahmed102' once he gets well, given the patient number as a parameter. Then test the procedure. (4marks) 2. Code a function called Dentist Services Function to return the number of years of services of a given dentist. (4marks) Dear students Below are the instructions for the practical test. Please read it carefully before preceding to the questions. 1. You have almost 24 hours to complete the practical test. 2. You have to submit the code and screenshots of the result via Blackboard link before the deadline. 3. The deadline is 07-05-2020 at 11:59 PM. Consider the following ERD for a Dental Clinic and solve the following questions. Dentist Appointment arch25) Voce Garrett GE uchar Details Patient Procedure contains patum.chart patamarchar25 arch25 chard pro Num.char t desorption varchar 2001 cost decima ) Section A: DDL and Relational Algebra (7marks) 1. Create the database by using SQL DDL commands and fill the tables with at least 3 rows. (5marks) 2. Code solutions to the following problems as a relational- algebraic expression: (2marks) a. Display all patients' names who have an appointment on 1-1-2020 b. Find dentists number and name who have 10 years of service and living in Muscat. Section B: DML (5marks) 1. Code the following problems in SQL commands: (2marks) a. Display all patients whose last name starts with Ali. b. Display the dentist name, grade, nurse name, grade, patient name, age, who live in Muscat. 2. Write the SQL code to change the address to Suhar for the patient whose patient number is 111. After you have completed the task, examine the results, and then reset the address to its original value. (3marks) Section C: PL/SQL (8marks) 1. Write a procedure called patient_delete_procedure to delete the patient 'ahmed102' once he gets well, given the patient number as a parameter. Then test the procedure. (4marks) 2. Code a function called Dentist Services Function to return the number of years of services of a given dentist. (4marks)