Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the directions below please create an E/R diagram as requested. Thank you lijay Community Hospital LAB 2 For this lab, please read the description

Using the directions below please create an E/R diagram as requested. Thank you image text in transcribed
image text in transcribed
lijay Community Hospital LAB 2 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: EmployeelD, 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. 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

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

Logic In Databases International Workshop Lid 96 San Miniato Italy July 1 2 1996 Proceedings Lncs 1154

Authors: Dino Pedreschi ,Carlo Zaniolo

1st Edition

3540618147, 978-3540618140

More Books

Students also viewed these Databases questions

Question

=+Is the fear appropriate for the audience?

Answered: 1 week ago