Ending:The clinic runs in two six hour shifts (7a.m to 2p.m) and (2p.m to 8p.m). Managershould be able to schedule doctors, nurses, and secretaries for shifts. Doctors arepaid by the government but the Manager is supposed to pay salary to all otheremployees based on their hours worked. The system should be able to store thisinformation and the manager should be able to generate a bi weekly report for thehours worked by the nurses and secretaries and therefore calculate their salaries(assume reasonable hourly rates for nurses and secretaries). QUESTION:Create a query that returns a list of all patients and their family member(add a column primary member id in the patient table; make one patientas the primary member and then create another column calledrelationship and add husband, wife, son, daughter etc.) ABC Walk-in Clinic is located in a large metropolitan cityThe clinic staffconsists of ten doctors, six nurses, five office secretaries, two administrativeassistants and one manager. First time Patients have to visit the clinic personallyand fill a registration form that contains their personal and health relatedinformation. An office secretary would then enter that information in the computerbased information system.Patients may become a permanent patient (at any time) for one of the doctors atthe clinic by filling up necessary forms (they are called enrolled patients) or theymay choose to come walk-in for every visit. (They usually called walk-in patients)Enrolled Patients may book their appointments online or by calling, the office andone of the secretaries would then book their appointment with their doctor on aparticular day/time. Any booked appointment may be cancelled up to 24 hours inadvance after which the clinic charges a fifty-dollar fine.During a visit to the clinic, a patient reports to the secretary and she either putshim in the walk-in queue or in case of patients with existing appointments, checksthem in. A Nurse then takes the patient to an examination room and writes down about her symptoms and other medical issues and then based on each individualpatient's needs may take their blood pressure, temperature, height, and weightand then enters all this information in the computer system.The clinic system should keep a track of patients' appointments and change thestatus accordingly: booked, cancelled, arrived, checked in, checked out, LWT(leftwithout treatment), No show etc. Healthcare is free in Canada and most people arenot charged any fee (clinic is paid by the government), however sometime a smallfee is charged for items not covered by the government such as Sick notes or fee ischarged from the patients who are not covered under the government healthcoverage (visitors etc.)Next, the doctor examines the patient and may order some diagnostic tests for thepatient (blood work, XRAY, Ultrasound etc). The doctor will enter patientsymptoms, her diagnosis and treatment (prescription medicines). The systemshould have the capability to store all of the above information entered by thedoctor for a patient's visit. The doctor may also refer the patient to a specialistdoctor and store this information in the system.When the results come back from the Laboratory, one of the nurses will review allthe reports and enter them in each patients file (electronic file within the clinicsystem). She may also call a patient to book a follow up appointment with a doctorin case of adverse results.

Dear Student, To list all patients and their family member we use the SELECT statement. And to add…

Answered: Create a query that returns a list of…

Computer Networking: A Top-Down Approach (7th Edition)

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...

See similar textbooks

Related questions

Question

Ending:
The clinic runs in two six hour shifts (7a.m to 2p.m) and (2p.m to 8p.m). Manager
should be able to schedule doctors, nurses, and secretaries for shifts. Doctors are
paid by the government but the Manager is supposed to pay salary to all other
employees based on their hours worked. The system should be able to store this
information and the manager should be able to generate a bi weekly report for the
hours worked by the nurses and secretaries and therefore calculate their salaries
(assume reasonable hourly rates for nurses and secretaries).

QUESTION:
Create a query that returns a list of all patients and their family member
(add a column primary member id in the patient table; make one patient
as the primary member and then create another column called
relationship and add husband, wife, son, daughter etc.)