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

Using an appropriate drawing/data modelling tool, develop an ERD
that meets the following guidelines.
• Draw the entities with their attributes.
• 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