Question
Provide all the SQL statements that are required for the following transactions to be executed: Create a record for a new staff member with the
- Provide all the SQL statements that are required for the following transactions to be executed:
- 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 12th July 2010. She also has a Post Graduate Diploma in Geriatrics from Enid Blyton University which as awarded on 22nd July 2012. Prior to starting at FSH, she worked at Eastern Hospital as a Charge Nurse between 23rd January 2011 and 1st May 2011. From 1st June 2011 until 23rd Feb 2012, she worked at Eastern Hospital as a Charge Nurse.
- Register a new patient (Anne Phelps) as per the details in Figure 1 below.
- 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)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started