CIS 336 iLab 2 The Expanded Entity Relationship Diagram FOR MORE CLASSES VISIT www . cis336study . com
transitive . Paste your solution into the answer sheet , and label it , Answer # 1 .
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