Created a database for hospitals so that doctors can manage information about their patients in a more organized manner. Doctors will be able to monitor a patient’s health conditions and medical records more efficiently, thus improving the quality of care provided to the patients.
Business Rules
Hospital employees are doctors and nurses
A hospital must have at least one doctor
A hospital must have at least one nurse
Each patient, nurse, and doctor has their own address
A patient may be admitted to hospital beds
A patient can visit to the hospital multiple times
A patient can get multiple prescriptions at any given time
A prescription can only be written by a doctor
