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 highquality, 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 NORMALIZED 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.

A Normalized ER/EER diagram of the following:

PATIENT K BED_TREATMENT PK FK Bed Number PK FK TreatmentCode PK PatientiD Name BED DOB Age Gender Address Email Phone DepartmentCode PK FK Bed Number Patienti PK TREATMENT TreatmentCode Treatment Description Treatment Cost Personnell FK FK BED_TEST PK FK Bed Number PK EK TestCode DEPARTMENT TEST PK PK Department Code DepartmentName PK PERSONNEL Personnell Name Phone TestCode TestDescription Testost Personnell FK - Email Address Hire-date position DepartmentCode FK