CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 45

in-home care includes the healthcare worker ID, their departure time
and return time, and also the prescription ID for any prescriptions
administered by the healthcare worker in the home setting.
The hospital administrator would like to know what home-care visits
have been made to whom, by whom, when, and how long they took.
There is concern at this point that the cost of providing limited home
healthcare is not providing adequate return on investment, and the
program should be revised or discontinued.
Requirements
You have been asked to develop a logical data model for University
Medical Center based on the information given to you by the new
hospital administrator and their staff. Through analysis of the nouns
and verbs in the case study above, you have accumulated the following
entity, attribute, and relationship information shown in the table
below. The attribute list may not be complete. If you determine that
additional attributes are needed to better define an entity, then you
should add them.
Entities Attributes and Relationships for University Medical Center
(Parallel Lab Exercise):
Entity Attributes Relationships
HealthcareWorkerHealthcareWorkerID, LastName, FirstName, SSN,
Address, City, State, Zip, Phone Number, HealthcareWorkerTypeID A
healthcare worker can belong to any one of the three job categories,
but can belong to one and only one of the three. healthcare worker has
names and other contact information.
HealthcareWorkerTypeHealthcareWorkerTypeID,
HealthcareWorkerTypeDesc, HourlyBillingRate A healthcare worker