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 entity-relationship 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:
Person_ID (identifier), Name, Address, City/State/Zip, Birth_Date, and Phone.
Each of the four groups of persons has at least one unique attribute of its own.
Employees have a Date_Hired, Volunteers have a Skill, Physicians have a Specialty
and a Pager#, and Patients have a Contact_date (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 (e.g., 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 Date_Admitted 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 Job_Class, 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 Bed_ID (identifier). Bed_ID 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!