INSTRUCTIONI have posted below the EER model you need to use while answering the question below.QUESTION 4. Create the following FOUR queries: Create a query that lists all patients who have not had any appointment in the clinic in the last 2 years (at least one patient) Create a query that returns the all appointment by a particular patient in the year of 2020 (should return 5 appointments at least) the result set would include patient names, examining doctors’ and nurses’ names, dates and times of the appointments, any tests ordered by the doctors for the Create a query that returns all appointments that were either cancelled, or patients were No Show in the month of December 2020. (five results minimum) Create a query that returns staff members’ names (excluding doctors), their hourly rates, number of hours worked, and Salary (calculated column; there are 13 employees in the clinic) for the two weeks period ( PatientsSecretaryPatientsID INTSecretaryID INTShiftsreports toO FirstName VARCHAR(45) HO Secretary_name VARCHA.ShiftsID INT8 more..в тore....Shift date VARCHAR(45)IndexesIndexes3 more...IndexesexaminesbookedschedulesDoctorsAppointmentManagerDoctorsID INTAppointmentID INTManagerID INTO Doctors_name VARCHA. +Appointment_date DATEH-Managers_name VARCHA...7 more.5 more..4 more.IndexesIndexesPaymentsIndexesPaym entsID INT-KO Fee charged VARCHAR(45)5 more...enters inquireswrites down medical issuesIndexesTestsNursesTestsID INT* NursesID INTreviews resultOTests_name VARCHAR(.HE:O Nurses_name VARCHAR(45)Administrative ..Staff Members3 more.6 more.Admin assistancelD INT? Staff Mem bersID INTIndexesIndexesAdmin assistance_name.O Department name VARC.4 more..2 more...IndexesIndexes

Note : As per guidelines , answering 1st 3 subparts of a question . Repost 4th part to get the…

Answered: Create a query that lists all patients…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

INSTRUCTION
I have posted below the EER model you need to use while answering the question below.

QUESTION

4. Create the following FOUR queries:

Create a query that lists all patients who have not had any appointment in the clinic in the last 2 years (at least one patient)

Create a query that returns the all appointment by a particular patient in the year of 2020 (should return 5 appointments at least) the result set would include patient names, examining doctors’ and nurses’ names, dates and times of the appointments, any tests ordered by the doctors for the

Create a query that returns all appointments that were either cancelled, or patients were No Show in the month of December 2020. (five results minimum)

Create a query that returns staff members’ names (excluding doctors), their hourly rates, number of hours worked, and Salary (calculated column; there are 13 employees in the clinic) for the two weeks period (