A hospital department wants to build a database to record and manage the information of its staff and patient. Following the analysis of the requirements, the following observations were made:
Every employee has a unique employee ID, and the information of name, sex, salary, qualification and experience. An employee has contact information of email and phone number, and every employee could have multiple contact numbers.
Employees include receptionists, nurses and doctors. The receptionist maintains the record of patients. The record has the information of appointment, record documents ID, patient ID and description.
The nurse manages the rooms for patients, and every patient is assigned a room for attending the appointment. The room has room ID, room type, and building name.
The patient attends the appointment to see the doctor. Doctors include visiting doctors, permanent-based doctors, and trainees. The patient has a patient ID, and the information of name, sex, age, address, admitted date and discharged date. A patient has a contact address and contact number, and the contact number could be more than one.
The patient is billed for the treatment, medicine and equipment usage. Each bill has an ID number, price and description. Medicine has medicine name, code, expiry date, and description. Equipment has ID, price, location, and description.
Draw an Enhanced Entity Relationship diagram (EER diagram) for this project. Be sure to indicate the various attributes of each entity and relationship set, and the relationship multiplicities; The notation illustrated in Figure 1 below must be used. Single or double lines should be used, independently of the default illustration in Figure 1, depending on the completeness of the specialisation. Additional lines or symbols could be used where necessary.