CIS 336 iLab 2 The Expanded Entity Relationship Diagram FOR MORE CLASSES VISIT www . cis336study . com
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 .
Be sure to include the minimum and maximum occurrences of each relationship ( cardinality ) and to supply a name to the relationship that