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 healthcare 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.
