Assignment Content.
Phoenix Hospital has now transitioned from paper charting to electronic charting. The managers at the hospital are trying to obtain some reports about patients and employees but are unsure of how to retrieve and organize data from the database. You inform management that as an INS you can query the database and Display results about the questions they have. The managers return with the following list of questions:
May we obtain a report of all the names of patients, doctors, and nurses in Phoenix Hospital? – how many patients do we have in the facility that are mate? What are their names, ages. and ID numbers?
How many female patients do we have in the facility? what are their names, ages, and ID numbers?
How many doctors do we have in the facility and what are their names, specialties, and medical license numbers?
What are the names of patients being followed by cardiologists, the name of the cardiologist, the patient’s room, and blood pressure?
What are the names, age. location, and education level of the patients ‘being followed by cardiologists?
What are the brand name and generic names of medications prescribed to the patients?
Which medications did Dr. Atwood prescribe to patients?
Which nurses distributed medications to the patient (ID Number 19 to 35) during the night,
H0w many doctors do we have in the facility and what are their names, specialties, and medical license numbers?
What are the names of patients being followed by cardiologists, the name of the cardiologist, the patient’s root, and blood pressure?
what are the names, age, location, and education level Of the patients being followed by cardiologists?
What are the brand name and generic names of medications prescribed to the patients?
Which medications did Dr. Atwood prescribe to patients?
Which nurses distributed medications to the patient (ID Number 19 to 35) during the night” shift from January 2019 to September 2019?
How many patients were admitted to the facility during the month of November 2018 and how many during December 2018?
How many patients were assigned to nurse Yuri Sirret?
How many patients were prescribed Vioxx?
What are the names of the patients who were prescribed Vioxx and had a heart attack?
How many of those patients died as a result of a heart attack?
Of the patients who died, what medication was being prescribed to them? For each of the management’s question above, write an SQL query that can be used to obtain the information they are requesting.
