A hospital department wants to build a database to record and manage the information of its staff
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Related Book For
Operations Management Processes And Supply Chains
ISBN: 9780136860938
13th Edition
Authors: Lee J. Krajewski, Manoj Malhotra
Posted Date: