Database Systems

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.

A database system for the Elijah Community Hospital would have many tables. By considering

the description of the Elijay Community Hospital, draw ER/EER diagram for the following

entities:

PATIENT: PatientID, Name, DOB, Age, Gender, Address, Email, Phone

BED: BedNumber, PatientID

PERSONNEL: PersonnelID, Name, Phone, Email, 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.