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.

Part 2:

Hand draw the high level E/R diagram for the hospital including all entities and relationships (do NOT include cardinalities for this lab).

Patient Care Administration

Patient ID

Patient Name

Patient Address

Patient Diagnosis

Appointment

Clinic and Lab Services Software

Record ID

Problem

Date of examination

Patient ID

Lab Tests

Patient Care Software

Labor and Delivery Services

Patient

Patient Diagnosis

Patient health insurance

Financial Management Software

Patient health Insurance

Billing & Invoicing

Inventory

Claims

Administrative Services Software

Janitorial Staff

Security Staff

Social Services

Management Staff