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 highquality, 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 outpatient 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

CSE $3153$ Lab $1$

Part $1$

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

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

Time Requirements

The lab will take about $2-3$ hours to complete. Be sure to give yourself enough time for completing this lab.

Submission

The lab should be submitted as an attachment through D$2$L in the dropbox.

Grading

Each part of the lab is worth $50\%$ of the grade. The lab will be graded on $80\%$ correctness and $20\%$ effort.

CSE $3153$ Lab $1$

Part $2$

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

Add your attributes to each entity you have drawn.

Time Requirements

The lab will take about $2-3$ hours to complete. Be sure to give yourself enough time for completing this lab.

Submission

The lab should be submitted as an attachment through D$2$L in the dropbox.

Grading

This lab is worth $50\%$ of the grade. The lab will be graded on $80\%$ correctness and $20\%$ effort.