Question: Please show the actual EER Model ExistingCondition (can have many existing conditions), and TravelHistory is recorded. - NON_COVID - is a patient diagnosed with other


Please show the actual EER Model
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
