Question: Need help with this ASAP. This is Database systems. Please draw out the EER Model and post the diagram and how it would look like
Need help with this ASAP. This is Database systems. Please draw out the EER Model and post the diagram and how it would look like thanks. Please only do if you know how to draw EER Model diagram. Thanks.


Develop an EER model for the following situation: After completing a course in database systems, you have been hired as an intern by a Community Hospital. You were assigned in a team tasked to develop a database design for the hospital's software system project - a Hospital Management System. This system also considers the coronavirus COVID-19 pandemic situation and wants to have a special monitoring for COVID-19 patients. After conducting a series of interviews with a number of hospital administrators and employees, you have identified the following entity types for the EER Model: - EMPLOYEE - is any person employed in the hospital. Each employee has an EmployeeID (identifier), Name, and DateHired. There are different types of EMPLOYEES and these are: DOCTORS, NURSES, and there are also other types of employees in the hospital. But, an employee must belong to only one type where an employee cannot do to the job of an employee with different job type. - DOCTOR - is an EMPLOYEE in the hospital. A doctor has a LicenseNo attribute. - NURSE - is an EMPLOYEE in the hospital. CareLevel needs to be recorded for each nurse. - CARE_UNIT - is a care center or station within the hospital. Each CARE_UNIT has a UnitID (identifier), and a UnitName. - ROOM - is a room in a certain care unit. A ROOM has a RoomNo (identifier), RoomType, and RoomPrice. - BED - is a hospital bed that may be assigned to a patient that will be admitted to the hospital. A BED cannot exist without being assigned to a ROOM, so that a BED depends on the ROOM. A BED has a BedNo (identifier), and a BedType. - PATIENT - a person who is either admitted to the hospital, or not. With special consideration to the COVID-19 pandemic, the hospital has only two patient classifications as COVID patients, or NON COVID patients. A patient must belong to only one classification. Each PATIENT has the following attributes: PatientID (identifier), PName (which is composed of FName, and LName), BirthDate, Gender, and ContactNo. - COVID - is a patient diagnosed with COVID-19 illness. For each COVID patient, the Status, ExistingCondition (can have many existing conditions), and TravelHistory is recorded. - NON COVID - is a patient diagnosed with other illnesses which is not COVID-19. Each NON COVID patient has an IllnessType attribute. - COVID_TEST - is a laboratory test given only to COVID patients. Each COVID TEST has a TestID (identifier), and a Description. Your team also noted the following information about relationships among entities: An EMPLOYEE supervises many employees, or may not supervise at all. But an EMPLOYEE must be supervised by exactly one employee. A DOCTOR must treat as a minimum one PATIENT; while, a PATIENT is treated by one or more DOCTORS. Every time a doctor treats a patient, the TreatDate, TreatDetails (which is composed of Medicine and Dosage), TotalCharges, InsurancePaid, and AmountDue (which is computed by subtracting the Insurance Paid from the Total Charges) are recorded. A COVID patient must undergo one or more COVID_TESTs. It is mandatory that COVID_TESTs are performed on one or more COVID PATIENTS. The attributes Date, and Result are recorded whenever a COVID patient undergoes a COVID_TEST. At a time, a NURSE is assigned to one and only one CARE_UNIT, but a CARE_UNIT must be assigned with one or more NURSEs. Moreover, one NURSE must manage a CARE_UNIT and each CARE_UNIT must be managed by exactly one NURSE. A CARE_UNIT has one or more ROOMS assigned to it. And, a ROOM is assigned to exactly one CARE_UNIT. A ROOM must have one or more BEDS. It is mandatory that a BED is assigned to a single (one) ROOM. A PATIENT is assigned to one BED if he/she needs to be admitted, if not, a patient is not assigned a bed. A BED may or may not be assigned to any PATIENT
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
