Design a database schema

Assignment Help Database Management System
Reference no: EM13358

Design a 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

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.

Reference no: EM13358

Reviews

Write a Review

 

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd