CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 53

• Indicate the relationships between the entities using Crow’s Foot
notation. You will need to determine the cardinality and optionality for
each direction of the relationships. Some of the Foreign Key
relationships are identified in the graph above but not all. Be sure you
identify and account for all Foreign Key relationships.
• Add a name (in both directions) to the relationships. Remember, if
you can verbalize the relationship in both directions, then you
probably have a valid relationship.
Deliverables
The deliverable for this lab will be your completed ERD as a single MS
Word document using copy/paste or imported as an image from your
drawing/modelling application, cropped and sized appropriately (it
should fit on a single page), and named lab2_solutions_yourname.
LAB STEPS
STEP 1: Drawing Entities and Attributes
Back to Top
Be sure to include all of the entities that have been defined. You need
to include at least the primary and foreign key attributes where
applicable in your diagram.
STEP 2: Add Relationships
Back to Top
Be sure that you link all entities based on PK to FK relationships.
There may be a case where you need to identify a combination PK and
if so make sure that all of the relationships involved are defined. Be
sure that you have set your drawing/modelling tool set to show Crow’s