Description
Instructions below.
Unformatted Attachment Preview
Database Systems Section W05
1. List all Patients and what Bed they are assigned to
SELECT p.id AS patient_id, p.name AS patient_name, p.address AS patient_address,
b.bed_number
FROM patient p
JOIN bed b ON p.id = b.patient_id;
2. List all patients who had Treatments and what Treatment they received
SELECT p.id AS patient_id, p.name AS patient_name, t.treatment_name
FROM patient p
JOIN treatment_history th ON p.id = th.patient_id
JOIN treatment t ON th.treatment_id = t.id;
3. List all patients who had tests and what Test they had
SELECT p.id AS patient_id, p.name AS patient_name, t.test_name
FROM patient p
JOIN test_history th ON p.id = th.patient_id
JOIN test t ON th.test_id = t.id;
4. List the employees (doctors, nurses, etc.) who assisted each patient.
SELECT p.id AS patient_id, p.name AS patient_name, per.id AS personnel_id, per.name AS
personnel_name
FROM patient p
JOIN appointment a ON p.id = a.patient_id
JOIN personnel per ON a.personnel_id = per.id;
5. List all patients in alphabetical order
SELECT * FROM patient
ORDER BY name;
6. List all patients who live in Atlanta and had a test completed
SELECT p.id AS patient_id, p.name AS patient_name, t.test_name
FROM patient p
JOIN test_history th ON p.id = th.patient_id
JOIN test t ON th.test_id = t.id
WHERE p.address LIKE '%Atlanta%';
7. List all patients who live in either Woodstock or Roswell who had a treatment
completed.
SELECT p.id AS patient_id, p.name AS patient_name, tr.treatment_name
FROM patient p
JOIN treatment_history th ON p.id = th.patient_id
JOIN treatment tr ON th.treatment_id = tr.id
WHERE p.address LIKE '%Woodstock%' OR p.address LIKE '%Roswell%';
Option 1
For this project - you will be writing a program (you may choose whatever programming
language you want) to read in two of your database tables from Lab 5, and then print out the
contents of each of the two tables separately. These MUST be database tables that have already
been created and stored as input for your program.
You may use either SQL code to select All of your tables and do a screen capture. Turn in a copy
of your SQL code, and a copy of the screen captured tables.
.
Purchase answer to see full attachment
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Studypool
4.7
Indeed
4.5
Sitejabber
4.4
Similar Content
Programming with Python Questions
Programming Assignment Instructions: In this programming assignment, students need to count the frequency of each alphabet...
ITSE1430 North Lake College C# Programming Language Project
Assignment details is in the attached PDF. End result should look like the images shown in the pdf. Please let me know if ...
Data Analysis and Visualization Python Coding Task
...
IT 411 DPU Creating a Simple Restaurant Web Page Interactive Scripting JQuery App
I don't believe supplemental materials are needed.I'm just not sure where to begin. Or end for that matter lol....
Write a Short Driver Program to Test Your Car Class Computer Programing Task
Implement a class Car, which contains the fields (5 points):make, e.g. Ford, Subaru, Toyota ...model, e.g., Escape, Outbac...
University of California Los Angeles Assert Statements Programming Code
...
New Doc 2020 02 21 12.22.00
...
Html Ans
You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the a...
Aggregating Data
On average, wives have a height of 1601.95 millimeters while the husbands’ height is 1731.49. As such, the husbands are ...
