Sign In
Not register? Register Now!
Essay Available:
Pages:
3 pages/β‰ˆ825 words
Sources:
4 Sources
Style:
APA
Subject:
Health, Medicine, Nursing
Type:
Research Paper
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 17.5
Topic:

SQL Queries The Following Database Schema

Research Paper Instructions:

For this assignment you will create SQL queries use the following database schema:
Patient—PatientID, Name, DOB
Doctor—DoctorID, Name, MedLicenseNumber, Phone
Medication—MedicationID, BrandName, GenericName
Prescription—PrescriptionID, Date, PatientID, PrescriberID, MedicationID
Specify the SQL queries to retrieve:
A list of all doctors.
The number of patients who were born before 01/01/1994.
The patient information along with the ID of any prescribing doctor for each patient.
The prescription information along with patient name, DOB, medication brand name, and prescribing doctor name sorted by most recent date.
The most prescribed generic medication name.

Research Paper Sample Content Preview:

SQL Queries
Author Name
Institution Affiliation
The following database schema has been used to create SQL queries.
Patient—PatientID, Name, DOB
Doctor—DoctorID, Name, MedLicenseNumber, Phone
Medication—MedicationID, BrandName, GenericName
Prescription—PrescriptionID, Date, PatientID, PrescriberID, MedicationID
PART 1
SELECT**FROM Doctor
With this query, it will be easy for us to obtain the columns from the table titled Doctor (Kellenberger & Shaw, 2014).
PART 2
SELECT COUNT(PatientIDs)FROM PatientsWHERE DATEOFBIRTH < 01/01/1994In this query, we will have information about how many patients were born before 01/01/1994 (Root & Mason, 2012). The patient IDs or the number of rows are to be listed here, and the data of patients who were born before 01/01/1994 has to be organized.
PART 3
SELECT P.*, S.PrescriberIDsFROM Patients PINNER JOIN Prescription S ON P.PatientIDs = S.PatientIDs
The patient information along with the doctor’s prescription and information are displayed here. For this purpose, we...
Updated on
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:
Order

πŸ‘€ Other Visitors are Viewing These APA Research Paper Samples:

HIRE A WRITER FROM $11.95 / PAGE
ORDER WITH 15% DISCOUNT!
Order Now