CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | Page 34

The following is some general information about the organization and its current
processes.
• The hospital operates three clinical facilities.
• A healthcare worker logs in at a facility at the start of a shift and logs out at the end.
• The name, address, Social Security number and other information is recorded for every
healthcare worker.
• All healthcare workers have one billing rate, which is determined by their job
description.
• Each medication dispensed by prescription is linked to both the prescription number and
the medication ID number, recording the item price and the quantity dispensed.
As a convenient and affordable means of providing hospice care, palliative care, and
convalescent care to patients that need occasional/intermittent skilled nursing, but do not
require hospitalization, the hospital offers limited in-home care. Recording of 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