CIS 336 STUDY Career Path Begins/cis336study.com CIS 336 STUDY Career Path Begins/cis336study.com | Page 43

2. Using the answer to exercise 1, remove all partial dependencies and
draw the new dependency diagrams. For each new table created,
specify its normal form (1NF, 2NF, 3NF). Paste your solution into the
answer sheet, and label it, Answer #2.
3. Using the answer to exercise 3, remove all transitive dependencies,
and draw the new dependency diagrams. For each new or revised
table, specify its normal form. Paste your solution into the answer
sheet, and label it, Answer #3.
4. Draw the ERD for exercise 3, using Crow‘s Foot notation. Paste
your solution into the answer sheet, and label it, Answer #4.
---------------------------------------------------------------------------------------

CIS 336 iLab 2 The Expanded Entity Relationship Diagram

FOR MORE CLASSES VISIT
www.cis336study.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