Database Schema-SQL Statements
Database Schema-SQL Statements
1) Based on the feedback received on your Topic 2 assignment Database Schema, provide SQL statements to create the (revised) database and populate it with sample data (at least four rows per table).
2) Modify the database by adding an additional column (”Deleted_Date”) to those tables that represent entities that could contain data which can be deleted and justify your rationale in a short paragraph. In addition, explain what the tradeoffs are in using a marker-column for deletion, as opposed to actually deleting a row from a table?
APA format is not required, but solid academic writing is expected.
This assignment uses a grading rubric. Instructors will be using the rubric to grade the assignment; therefore, students should review the rubric prior to beginning the assignment to become familiar with the assignment criteria and expectations for successful completion of the assignment.
You are not required to submit this assignment to LopesWrite.
SQL Queries
Struggling to meet your deadline ?
Get assistance on
Database Schema-SQL Statements
done on time by medical experts. Don’t wait – ORDER NOW!
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.
APA style is not required, but solid academic writing is expected.
You are not required to submit this assignment to LopesWrite.
Topic 4 DQ 1
How important are naming conventions in database modeling? What comes first: the need for a report or the data?