1. Provide all the SQL statements that are required for the following transactions to be executed:
   1. Create a record for a new staff member with the following details: Moira Samuels, 49 School Road, Bedford, W.A., 6052. She is female, her date of birth is 30 May 1990, and her telephone number is 0150-456-3357. Her current position is Charge Nurse in Ward 11. Her current salary is $68760 and she is working 37.5 hours per week on a permanent basis. She is paid monthly. She has a BSc in Nursing from Curtain University which was awarded to her on 12^th July 2010. She also has a Post Graduate Diploma in Geriatrics from Enid Blyton University which as awarded on 22^nd July 2012. Prior to starting at FSH, she worked at Eastern Hospital as a Charge Nurse between 23^rd January 2011 and 1^st May 2011. From 1^st June 2011 until 23^rd Feb 2012, she worked at Eastern Hospital as a Charge Nurse.
   2. Register a new patient (Anne Phelps) as per the details in Figure 1 below.
   3. Allocate the staff to Ward 11 as per Figure 2 below. You do not need to include the statements required to create the records of the staff named in the Figure.

Felicity Stillwell Hospital
Patient Registration Form
Patient Number:							P10234
Personal Details
Family Name:			Phelps
Given Names:			Anne
Street Address:			67 Wellmeaning Way
Suburb:	Wellington			State:	WA	PostCode:	6856
Gender:	F		Date of Birth:		10/12/1955
Marital Status:			M	Telephone No:		0131-332-4158
Next-of-Kin Details
Full Name:			James Phelps
Street Address:			67 Wellmeaning Way
Suburb:	Wellington			State:	WA	PostCode:	6856
Relationship:		Spouse		Telephone No:		0131-332-4158
Local Doctor Details
Full Name:			Dr Helen Pearson
Street Address:			47 Kennedy Street
Suburb:	Murrayville			State:	WA	PostCode:	6855
Provider No:		1455784L		Telephone No:		0131-332-6282

Figure 1

Felicity Stillwell Hospital
Ward Staff Allocation
Week Beginning:					9/01/2020
Ward Number:	11	Ward Name:		Orthopaedic
Location:	Block E	Telephone Extension:		7711
Charge Nurse:	Moira Samuel		Staff Number:			S4576
Staff Allocation Listing
Staff No:	Name		Position		Shift
S0980	Carol Cummings		Staff Nurse		Late
S1257	Morgan Russell		Nurse		Late
S1458	Robin Plevin		Staff Nurse		Early
S2356	Amy O'Donnell		Consultant		Night
S3649	Laurence Burns		Nurse		Early

Figure 2

LocalDoctor Provide_Num Int Full_Name Varchar(45) Next_of_Kin Patient_ID INT Full_Name Varchar(45) Relationship Varchar(45) Employee_Contract StreetAddress Varchar(45) HU Staff Number INT Suburb Varchar(45) StressAddress Varchar(45) PerWeekHours INT State Varchar(45) Suburb Varchar(45) Postcode Varchar(45) State Varchar(45) Contract_Mode Varchar(45) Payment_Mode Varchar(45) Telephone_Num Varchar(45 Postcode Varchar(45) Telephone_Num Varchar(45 Qualifiaction Staff_Number INT Date OfQualification Date Patient In Patient Type Varchar(45) Patient_ID Int Patient_id INT Staff Name_Of_Institution Varchar(45) ++ Staff_Number INT + First_Name Varchar(45) Last_Name(Varchar) E FirstName Varchar(45) LastName Varchar(45) Suburb Varchar(45) State Varchar(45) Waiting_Start_Date DATE Expet_Stay INT Ward_Placing_Date DATE Expected_Leave_Date DATE Suburb Varchar(45) H- Experience Staff_Num INT Postcoade Varchar(45) Actual_Leave_Date DATE State Varchar(45) Dob DATE + Bed No INT Postcode Varcahr(45) Organisation Varchar(45) Position Varchar(45) Srart_Date DATE StreetAddress Varchar(45) Contract_ID INT Marital_Status Varchar(45) End Date DATE Registration_Date DATE Telephone_num Varchar(45) Local Doctor INT E Appointment Appointment_ID INT Patient_ID INT Staff_ID INT Appointment_Date DATE Examination_Room INT Ward Ward_Staff Ward_No INT Staff_No INT Role Varchar(45) Ward_No INT Name Varchar(45) Location Varchar(45) Total_Beds INT Tele_Extension_No Varchar(45)