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: 1. Patient care administration software-record keeping aspects of patient care 2. Clinic and lab services software-provides lab testing and procedures and patient monitoring & screening 3. Patient care software-provide patients with medical care and support services 4. Financial management software-manage the financial resources and operations of the hospital 5. Administrative services software-provide general management and support services not directly related to patient care The patient care and clinic and lab services include: laboratory tests, radiology procedures, admissions, in-patient and out-patient surgeries, labor and delivery services, intensive care, cardiology, open-heart surgery, neurology department, pediatric medical and surgical care, orthopedics, oncology and a 24-hour emergency department. The staff on the hospital include 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.

Lab 2.

We need to create E/R diagram that SHOWS the cardinalities among different entities.

Patient Care Administration (business function) -Patient(entity) Lab Reports(entity) Admission(entity) InPatient(entity) Doctors(entity)

Clinical and Lab Services (business function) -Patient(entity) Lab Reports(entity) Radiology Reports(entity) InPatient(entity)

Patient Care Software (business function)-Patient(entity) Lab Results(entity) Room Booking(entity)

Financial Management Software (business function) -Medical Bills(entity)

Administrative Service Software (business function) Patients(entity) Medical Bills(entity) Room Booking(entity)