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

Be sure to include the minimum and maximum occurrences of each
relationship (cardinality) and to supply a name to the relationship
that will work in both directions. Make sure to use Crow‘s Feet
notation in your ERD.
Narrative/Case Study
The University Medical Center is a small, community hospital. A
new hospital administrator has recently been hired by the Board of
Directors, and directed to right-size patient care and pharmacy
services and improve profitability. The hospital operates three
clinical facilities: the main hospital, a mid-town clinic, and an
Urgent Care location. The hospital also offers selected in-home care
services. Many of the patients are repeat or regular patients who
receive regular treatment for various conditions, and many utilize
the hospital‘s pharmacy services for prescription medications.
The pharmacy dispenses about 3,000 different prescription
medications of various kinds. Every prescription is associated with
one patient, and is logged by the dispensing clinic. The new
administrator wants to know which drugs are most prescribed, and
also which are the most profitable.
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.