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.