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

Elijay Community Hospital

LAB 1

Part 1:

For this Lab you will do the following based on the explanation of the Elijay Community Hospital:

Using the Business Functions identified in the description of the Elijay Community Hospital -List the various Entities that support EACH Business function (done in Word) - each business function should have a separate list of entities associated with it. Example: Patient Care Administration (business function) Patient (entity), etc.

Clinical Services (business function)

Patient (entity) Lab Test (entity), etc.

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

Ind Lab 2
Instructions
For this lab we will take our E/R diagram from lab 1 part 2 and redraw it (after using the feedback and other information given in Module 3 - with the extended E/R diagram information. what I need you to do is draw a E/R diagram for Lab 2. And If you need any more information , you can email 564655003@qq.com And Also this is a lot of work. I can pay it. Please contact me. This course is Database System.