CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Page 44

• 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