UM hospital is a hospital that includes several departments and ward such as Orthopaedic, Pathology, Emergency, Dental, Gynaecology, Anaesthetics, I.C.U., Blood Bank, Operation Theater, Laboratory, M.R.I., Neurology, Cardiology, Cancer Department, Corpse, etc. Each department has its own consultants, specialists, medical officer, houseman, medical assistant, staff nurses, and cleaners. Patients having different kinds of illness will go to the specific department to get treatment and medication. If required, patients are admitted in the department ward and discharged after treatment.

When patients go to the department front counter, they will be registered by the staff nurses. Medical assistants will then take each patients history of illness and do a blood pressure check. The report will be sent to the doctor, and the doctor will check up their illness. Based on the treatment, specific medication is prescribed, and the patient can go home. If the patient needs to be warded for further treatment, a bed in ward will be assigned to them, and their daily progress will be monitored and recorded. After the treatment in the ward is completed, the doctor discharges the patient, and the finance department will calculate all the costs that need to be paid by the patient.

REQUIRED

(a) Given the case study, identify FIVE (5) main entities involved in the situation. (2.5 Marks)

(b) For each of the entities, identify the primary key and TWO (2) other attributes. (7.5 Marks)

(c) Using the Crow’s foot notation, create a complete Entity Relationship Diagram which includes all the Primary Key, Foreign Key, Relationship and Cardinalities based on the case study.
(10 Marks)