Database

The logical phase of the database design process has provided the following relations for a database that was proposed to support the administration of a Private Surgery in Liverpool Patient (P Code, P Surname, P Firstname, P Sex, PDoBirth, P Occupation, P Height, P Weight, P Address, P MobileNo Doctor (D Code, D SurName, D FirstName, D PrivateAddress, DMobileNo, Function) Operation (OCode, P Code, D Code, Date, Time, Result, O Type) Is_Examined By (P_Code, D Code, Date, Time Location). Write the following queries in "RELATIONAL ALGEBRA", for the above relations 1. Find the Operation Types that have been done on the 22d of December of 2018 and have been successful. 2. Find the name, gender and age of all patients that have been seen by "Mr. Alex" and have been operated on by doctor "Dr. Henson", assuming that there are no doctors with the same surname 3. Find the first Name, Last Name, Address and Gender of the patients that have been operated on by doctor "D7679" and results have been successful. 4. Find the Full details of the patients that have had at least an operation with broken arm, with full details of the doctor which has been assigned to look after this patient. 5. Find the details of all patients that have shared any doctors with the patient that has the code "P898". This should include the name of the doctor and his contact detail