Provided the following design for a database :

Doctor (DoctorName, Gender, RegistrationNumber, Qualification);

Patient (PatientNumber, Gender, DOB, Address, PhoneNumber);

Appointments (DoctorName*, PatientNumber*, AppointmentDate, AppointmentTime, Type);

NOTE : IN ITALICS ARE PRIMARY KEYS

complete below tasks to populate your database with the data shown in Table 1.

Table 1.

2.1. (5 marks) Give the CREATE TABLE statement for each relation, including primary key and any foreign key constraints.

2.2. (5 marks) Give the INSERT INTO statements for each relation in your design. All data shown in Table 1 must be inserted into your database.

Appoint Doctor Name Gender Patient Name Gender DOB Address Appoint date Type number Bachelor of Medicine and Surgery Deakin University, 1980 Bachelor of Medicine and Surgery Deakin University, 1930 Bacbelor of Medicine and Surgery Steven Aow M Will Smith M 15/121965 3 Farmer Street, Melboume, 3001 30001234 15/04/2017 1000 long 1001/1970 15 Happy Lane, Prahan, 3015 15121965 Storey Drive, Preston, 3147 15/12/1965 3Farmer Street, Melboume, 3001 30001234 20105/2017 15:00 hort /04/1980 109 Cardigan Street, Carlton, 3003 10901980 1105/2017 1030 long 12/05/2001 23 Tmart Street, Malvem, 3145 23002001 26/06/2017 9:30 short /03/2007 3Farmer Street, Melboume, 3001 30001234 30/06/2017 14:00 long 19/10/1980 45 Water Lane, Fitzroy, 3078 20/04/1998 26 May Street, Kew, 3125 15/12/1965 7 Storey Drive, Preston, 3147 Steven Aw M . Jade Liew F ABC001 15001234 15/04/2017 1030 shor and Surgery. Deakin University Alex Lade Steven Aow M Stanley Bill M Stanley Bill M Stanley Bill Kate Cox ABC001 ABCOOL 70001965 28/05/2017 14:00 ong , 1980 Bachelor of Medical Science, The University of Melbourme, 1982 Bachelor of Medical Science, The University of Melbourne, 1982 Emly Moo Will Smith F M AXG0 Bachelor of Medical Science. Tbe Bob Jane M Unuversiry of Melboume, 1982 BITO01 Master of Clinical Medicine BITO BM 345 Will Smith M Monash Uruversity, 2000 Master of Clinical Medicine Monash University, 2000 Master of Medicine, The University of Melbourne, 2000 Master of Medicine, The University of Melbourne, 2000 Kate Cox Danuel Water M 5001980 30/06/2017 15:30 short 26001998 28/04/2017 16:00 short 70001965 30/04/2017 13:00 short Max Fat M Arran May M Max Fat Alex Lade MM