Homework answers / question archive / Please submit two files, one contains your queries and other one contains all screen shots of running queries

Please submit two files, one contains your queries and other one contains all screen shots of running queries

Computer Science

Share With

Please submit two files, one contains your queries and other one contains all screen shots of running queries.  Work submitted in more than two files will not be evaluated.For this lab you will be using SQL SELECT statements to query your database tables.  You will be turning in the results of the following queries:1. List all Patients and what Bed they are assigned to (Join two tables patient and bed).2.  List all patients who had Treatments and what Treatment they received (Join three tables Patient, Treatment, and Patient-Treatment)3.  List all patients who had tests and what Test they had (Join three tables Patient, Test, and Patient-Test).4.  List the employees (doctors, nurses, etc.) who assisted each patient (Join three tables: Patient, Personnel, and Patient-Personnel).5.  List all patients in alphabetical order6.  List all patients who live in Atlanta and had a test completed (Join three tables Patient, Patient-Test, test).7.  List all patients who live in either Woodstock or Roswell who had a treatment completed (Join three tables Patient, Patient-Treatment, treatment).If you don't have data in your created tables that will allow you to create these queries - add appropriate data to your tables before doing the queries.Turn in all queries, each "screen shot" of each query and each of your tables with all of the data.