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

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 the entity that will be helpful in determining its
relationship to other entities within the model.