Question: Develop an enhanced entity - relationship diagram for the following project description. As a large service organization, Mountain View Community Hospital depends on a large
Develop an enhanced entityrelationship diagram for the following project
description.
As a large service organization, Mountain View Community Hospital depends on a
large number of persons for its continued success. There are four groups of persons
on whom the hospital is most dependent: employees, physicians, patients, and
volunteers. Of course, some common attributes are shared by all of these persons:
PersonID identifier Name, Address, CityStateZip BirthDate, and Phone.
Each of the four groups of persons has at least one unique attribute of its own.
Employees have a DateHired, Volunteers have a Skill, Physicians have a Specialty
and a Pager# and Patients have a Contactdate date of first contact with the
hospital Some other persons in the hospital community do not belong to one of
these four groups their numbers are relatively small
However, a particular person may belong to two or more of these groups at a given time eg Patient and Volunteer
Each patient has one and only one physician responsible for that patient. A given
physician may not be responsible for a patient at a given time, or may be responsible for one or more patients. Patients are divided into two groups: resident and outpatient. Each resident patient has a DateAdmitted attribute. Each outpatient is scheduled for zero or more visits. Visits are characterized by a Date.
Employees are subdivided into three groups: nurse, staff, and technicians. Only nurse has the attribute Certificate, which indicates the qualification RN LPN etc. Only
staff has the attribute JobClass, and only technician has the attribute Skill. Each
nurse is assigned to one and only one care center. Attributes of care center are
Name identifier and Location. A care center may have one or more nurses assigned
to it
Each technician is assigned to one or more laboratories. Attributes of laboratory
include Name identifier and Location. A laboratory must have at least one technician assigned to it and may have any number of technicians assigned.
A care center may have one or more beds up to any number assigned to it The only attribute of bed is BedID identifier BedID is a composite attribute, with
components Bed# and Room# Each resident patient must be assigned to a bed. A bed may or may not have a resident patient assigned to it a given time but will be assigned to many resident patients over time.
Can you sketch this on paper or create a diagram in Lucidchart to help better understand the problem?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
