Question
URGENT: Please answer as if you are solving the questions using Excel: For the following questions, imagine the Patient, Prescription, and Appointment tables from questions
URGENT:
Please answer as if you are solving the questions using Excel:
For the following questions, imagine the Patient, Prescription, and Appointment tables from questions 1-5 all exist in different Excel files.
6. Briefly explain how you would add the name of each patients most recently prescribed medication to the file containing the patient table [Your resulting data will be the patient table, with an additional column (called last_prescribed_med) for each patients most recently prescribed medication]
7. Briefly explain how you would add the name of each patients most frequently prescribed medication name to the file containing the patient table [Your resulting data will be the patient table, with an additional column (called most_frequent_med) for each patients most frequently prescribed medication]
8. Briefly explain how you would obtain the number of distinct medications that were prescribed in the dataset. Provide two different methodologies.
9. Briefly explain how you would determine the number of patients who were prescribed a medication on the day after they had an appointment.
Imagine a simplified data-model with the following 3 tables: Patient Stores patient-level information and demographics. Indicator Column Name PK patient_id first name last name Description Primary Key Patient First Name Patient Last Name Additional Columns Prescription - Stores information on prescriptions written for the patients. Indicator Column Name Description PK prescription_id Primary Key FK patient_id Foreign Key to the Patient table prescription_date Date on which the prescription was written medication Name of the Medication prescribed provider_first The first name of the Doctor or other provider that prescribed the medication provider last The last name of the prescribing provider Additional Columns Appointment - Stores information on patient's scheduled appointments. Indicator Column Name Description PK appointment id Primary Key FK patient id Foreign Key to the Patient table appointment_date Date on which the appointment is scheduled provider_first The first name of the Doctor (or other provider) that patient is scheduled to see provider_last The last name of the provider Additional columns Imagine a simplified data-model with the following 3 tables: Patient Stores patient-level information and demographics. Indicator Column Name PK patient_id first name last name Description Primary Key Patient First Name Patient Last Name Additional Columns Prescription - Stores information on prescriptions written for the patients. Indicator Column Name Description PK prescription_id Primary Key FK patient_id Foreign Key to the Patient table prescription_date Date on which the prescription was written medication Name of the Medication prescribed provider_first The first name of the Doctor or other provider that prescribed the medication provider last The last name of the prescribing provider Additional Columns Appointment - Stores information on patient's scheduled appointments. Indicator Column Name Description PK appointment id Primary Key FK patient id Foreign Key to the Patient table appointment_date Date on which the appointment is scheduled provider_first The first name of the Doctor (or other provider) that patient is scheduled to see provider_last The last name of the provider Additional columnsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started