Elijay Community Hospital

You have been asked to develop a database system for the Elijah Community Hospital. ECH is a

small, local community hospital with approximately $125$ beds. The basic goal is to provide high$-$

quality, cost$-$effective health$-$care services for the surrounding community in North Georgia.

The various business functions that the hospital currently has are:

Patient care administration software$-$record keeping aspects of patient care

Clinic and lab services software$-$provides lab testing and procedures and patient

monitoring & screening

Patient care software$-$provide patients with medical care and support services

Financial management software$-$manage the financial resources and operations of the

hospital

Administrative services software$-$provide general management and support services not

directly related to patient care

The staff on the hospital includes $600$ full$-$time and $200$ part$-$time personnel including doctors,

registered nurses, laboratory technicians, counselors, rehabilitation therapists, social services

staff, admittance$/$discharge staff, insurance staff, janitorial staff, and security staff.

Patients may get many services from personnel, many tests and many treatments on the hospital.

A database system for the Elijah Community Hospital would have many tables. Draw ER$/$EER

diagram for the following entities:

PATIENT: PatientID, Name, DOB, Age, Gender, Address, Email, Phone $($one or two$)$

BED: BedNumber, PatientID

PERSONNEL: PersonnelID, Name, Phone, Email $($one or two$),$ Address, Hire$-$date, Position

DEPARTMENT: DepartmentCode, DepartmentName

TREATMENT: TreatmentCode, TreatmentDescription, TreatmentCost

TEST: TestCode, TestDescription, TestCost

Add new attributes to several of your entities if there is a need.

Note: use Dia tool or Visio to draw the diagram.

For this lab, we consider Elijay Community hospital hires full time and part time

personnel. The hospital has also two types of patients, Resident patient and out

patient.

First apply the feedback of Lab $1$ on your Lab $1\frac{E}{R}$ diagram.

Convert & Complete your previous ER Diagram with the extended E$/$R diagram

information $($EER diagram$)$ considering Elijay Community hospital hires full time and

part time personnel. The hospital has also two types of patients, Resident patient and

outpatient. Check the pdf again for complete instructions.