Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Elijay Community Hospital You have been asked to develop a database system for the Elijah Community Hospital and ER/EER diagram then NORMALIZE it. ECH is

Elijay Community Hospital You have been asked to develop a database system for the Elijah Community Hospital and ER/EER diagram then NORMALIZE it.

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

A database system for the Elijah Community Hospital would have many tables.

By considering the description of the Elijay Community Hospital, draw ER/EER diagram for the following entities:

PATIENT:

PatientID, Name, DOB, Age, Gender, Address, Email, Phone

BED: BedNumber, PatientID PERSONNEL:

PersonnelID, Name, Phone, Email, 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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Database Foundations Technology Fundamentals For IT Success

Authors: Bob Bryla

1st Edition

0782143725, 9780782143720

More Books

Students also viewed these Databases questions