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

For more course tutorials visit
www.uophelp.com
CIS336 Lab 2: The Expanded Entity Relationship Diagram
LAB OVERVIEW
Scenario and Summary
This lab introduces the next step in creating a data model, the Entity Relationship
Diagram (ERD). You will be given a business scenario for a University Medical Center,
which is a small community hospital. The business specifications will outline a number
of things about the business, some of which will apply directly to the database you are
being asked to model. There is a table that lists the entities (tables) that will be needed for
the database and related attributes (columns) for each entity. There is also a column that
lists specific information about the entity that will be helpful in determining its
relationship to other entities within the model.
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.