Question

If Using Dia, please provide a screenshot of the entire assignment. If not, a screenshot from another source is still great!

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

***** For this lab, please read the description of the Elijay Community Hospital and then complete the E/R diagram for the following entities:

PATIENT: PatientID, Name, DOB, age, gender, address, email, phone

BED: BedNumber, PatientID

EMPLOYEE: EmployeeID, Name, phone, email, phone, address, HireDate

DEPARTMENT: DepartmentCode, DepartmentName

TREATMENT: TreatmentCode, TreatmentDescription, TreatmentCost

TEST: TestCode, TestDescription, TestCost

Add new attributes to several of your tables if there is a need.

Thanks!

Answer 1

According to the data provided for ELIJAY COMMUNITY HOSPITAL,

The main components of entire system are:

1) Patients

2) Employees of Hospital (Doctors, Nurses,Consultants,Lab Assistants etc)

3) Financial Data of Hospital ( Expenditure, Salaries of employee,Billings of patients, etc)

4) Structure of Hospital ( Departments, Labs, Operation theatres etc)

The E-R diagram is as follows: