plzzz help

Question 7(6 marks) Given the following relational schema: Patient(Patientld, FirstName, LastName, Occupation) Doctor(Doctorld, Surname, OfficePhone) Appointment(Patientld*, Doctorld*, AppointmentDate, AppointmentTime) (a) Write the SQL code required to build these tables in an Oracle environment. The Doctorld and PatientId attributes are both 6 digit numbers, (b) Write the SQL statement needed to add a patient record for a school teacher called Mrs Alice Jones. (c) Write the SQL statement needed to delete all appointment records for a patient with a PatientId of 987656. Question 8(2 marks total) In the answer booklet Draw a Wait-For-Graph to illustrate a deadlock situation between 3 transactions, T1, T2 and T3. Question 9(4 marks total) a) Define the term 'database recovery'. b) List 3 types of failures that can cause problems for databases that need correction via database recovery. Question 10(5 marks total) CustomerId State/Account | AccountBalance SalesRepId Sales RepName Open or losed 777 NSW/Open 1000.66 Brown 545 ACT/Closed Brown 875 NSW/Open 2345.99 Chan 1 654 VIC/Closed 10 Abide 887 VIC/Open 234.20 Chan 543 QLD/Closed 0 Hicks Given the Customer table above, where the CustomerID is the primary key and any dependencies found in this data set can hold for all time: (a) Describe any aspects of this table that would prevent it from meeting the criteria for First Normal Form? (b) Are there any transitive dependencies in this table? If 'yes' describe. 9