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 existingconditions), and TravelHistory is recorded. - NON_COVID - is a patient diagnosed

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!