Produce a list of all medication codes used in the clinic

Assignment Help Computer Engineering

Reference no: EM132213984

Write SQL for Microsoft Access Queries

Given Tables

Assignment Table - Attributes: Physician_ID, Patient_No, Role

Diagnosis Table- Attributes: Patient_No , Illness_Code

Illness Table- Attributes: Illness_Code, Illness_Desc , Department

Medication Table- Attributes: Medication_Code, Medication_Desc , On-Hand, On_Order, Unit_Cost

Patient Table - Attributes: Patient_No, Last_Name, First_Name, Gender, Age, Admit_Date, Room, Bed

Physician Table- Attributes: Physician_ID, Last_Name, First_Name, Tel_Ext, Specialty

Prescription Table- Attrubites: Pres_No, Patient_No, Medication_Code, Dosage

Contruct Queries based on the following

Produce a list of all medication codes used in the clinic, sorted alphabetically. Also, show the number of patients to whom each medication has been prescribed.

List the medication prescribed for patients who are in for ‘Cardiac Arrest'; Show patient first and last name, gender, age, room number, illness name, medication name, and dosage.

[Use join query]

Who are the doctor(s) that are attending to ‘Heat Exhaustion'? List the name of the doctor(s) and specialty.

[Write nested sub queries]

Produce a list of patients who were prescribed ‘Keflin'. The list should contain the patient name, medication name, dosage, illness description, and the doctor's name.

[Use join query]

List names (first and last) and telephone extension of doctors who have a patient that is in for ‘Work Stress'.

[Write nested sub queries]

List the names of doctors who have a patient that is NOT IN for ‘Compound Fracture' OR have no patients.

[Write nested sub queries]

List the patients who do not have a prescription. The list should show the patient's name, gender, age, admission date, room, and illness description.

[Use combination of Join and nested sub query]

Reference no: EM132213984

Questions Cloud

Write a statement to convert and assign a users input : Write a statement to convert and assign a user's input through text box to the fist element of ArrayNumber.

Create an array named numbers to hold 10 double values : Create another array named "numbers2" with initial values 5.7, 9.1, 7.21, and 8.4, using the array initializer.

Find the name and population of the planet with a population : Write an SQL query to find the name and population of the planets with a population larger than 2,600,000,000 given.

Write a code that inputs data from the standard input device : Write a C++ code that dynamically creates a two-dimensional array of five rows and seven columns and sales contains the base address of that array.

Produce a list of all medication codes used in the clinic : Produce a list of all medication codes used in the clinic, sorted alphabetically. Also, show the number of patients to whom each medication has been prescribed.

Create a view to join warehouse and inventory : Create a VIEW to join WAREHOUSE and INVENTORY and include all rows of WAREHOUSE in your answer, regardless of whether they have any INVENTORY.

Write a single python class that can by used to represent : Write a single Python Class that can by used to represent a Student object. It should be "constructible" with a name (in Last, First format) and a student ID.

Write a single program that call three functions in c : Write a single program that call three functions in C. Have the three functions each create/initialize an array but have one that declares and initialize .

Write a statement that reads a users input integer : Write a statement that reads a user's input integer into the defined variable, and a second statement that prints the integer. Do not end with a newline.

User Account

All Pages