CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 48

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
Foot notation. Also, be sure that you are defining the correct
cardinality for the relationships.