CIS 336 All Assignments CIS 336 All Assignments | Page 36

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.
STEP 3: Naming of relationships
Back to Top
If your drawing/modelling tool creates a default name for relationships, do not simply accept
this default without due consideration. There may be some relationships where the default is
applicable, but in most cases you will want to explicitly name the relationship. Be sure that you
have provided a verb phrase for both directions in the relationship.
This is the end of lab #2
CIS 336 iLab 3 Building the Physical
Click Below Link To Purchase
www.foxtutor.com/product/cis-336-ilab-3-building-the-physical
CIS-336: Lab 3: Building the Physical
LAB OVERVIEW
Scenario and Summary
The lab for this week addresses taking a logical database design (data model) and transforming
it into a