CIS 336 All Assignments CIS 336 All Assignments | Page 32

Click Below Link To Purchase
www.foxtutor.com/product/cis-336-ilab-2-the-expanded-entity-
relationship-diagram
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.