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

Patients may get many services from personnel, many tests and many treatments on the hospital.

A database system for the Elijah Community Hospital would have many tables. Draw ER$/$EER

diagram for the following entities:

PATIENT: PatientID, Name, DOB, Age, Gender, Address, Email, Phone $($one or two$)$

BED: BedNumber, PatientID

PERSONNEL: PersonnelID, Name, Phone, Email $($one or two$),$ Address, Hire$-$date, Position

DEPARTMENT: DepartmentCode, DepartmentName

TREATMENT: TreatmentCode, TreatmentDescription, TreatmentCost

TEST: TestCode, TestDescription, TestCost

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

Note: use Dia tool or Visio to draw the diagram.

Grading rubic:

File Submission: $20$ points

Submit the assignment file: $20$ points

Attributes: $25$ points

Maintaining all required attributes: $10$ points

Maintaining all Key attributes: $5$ points

Maintaining all Derived attribute: $2$ points

Maintaining all Multi value attribute: $4$ points

Maintaining all Composite attribute: $4$ points

Entities: $30$ points

Total $6$ Entities$-5$ points each

Relationships: $25$ points

Total $5$ relations$-5$ points each

Incorrect or no cardinality like one$-$to$-$one, one$-$to$-$many etc$-(-2\mathrm{.}5$ points for each mistake$)$