SQL Queries Assignment
Please follow the grading criteria before starting
SQL Queries Assignment
1 For this assignment, use the following database schema:
1 Patient—PatientID, Name, DOB
2 Doctor—DoctorID, Name, MedLicenseNumber, Phone
3 Medication—MedicationID, BrandName, GenericName
4 Prescription—PrescriptionID, Date, PatientID, PrescriberID, MedicationID
2 Specify the SQL queries to retrieve:
1 A list of all doctors.
2 The number of patients that were born before 01/01/1994.
3 The patient information along with the ID of any prescribing doctor for each patient.
4 The prescription information along with patient name, DOB, medication brand name, and prescribing doctor name sorted by most recent date.
5 The most prescribed generic medication name.
SQL Queries Grading Criteria
|
Assignment Criteria |
Possible Points |
Points Earned |
|
Specify the SQL queries to retrieve: |
||
|
A list of all doctors. |
1 |
|
|
The number of patients that were born before 01/01/1994. |
1 |
|
|
The patient information along with the ID of any prescribing doctor for each patient. |
3 |
|
|
The prescription information along with patient name, DOB, medication brand Name, and prescribing doctor name sorted by most recent date. |
3 |
|
|
The most prescribed generic medication name. |
2 |
|
|
Total |
10 |
|
To calculate the total score (total earned) / 10 x 10 =
-
Rating:
/5
Solution: SQL Queries Assignment