Posted: March 26th, 2021

Er diagram and relational schema solution

The relational schema shown below is part of a hospital database. 

Patient (patientNo, patName, patAddr, DOB)
Ward (wardNo, wardName, wardType, noOfBeds)
Contains (patientNo, wardNo, admissionDate)
Drug (drugNo, drugName, costPerUnit)
Prescribed (patientNo, drugNo, unitsPerDay, startDate, finishDate)

Need some help creating SQL statments for the following:

1.) List each patient that was admitted in August 2011.
2.) List each patient, every drug they are prescribed and the cost per day of that drug.
3.) List each patient, and the cost per day of all drugs they are being prescribed.
4.) Change the costPerUnit of ‘Morphine’ to $10.00.

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00