CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | Page 37

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
For more course tutorials visit
www.uophelp.com
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
physical model (tables, constraints, and relationships). As part of the lab, you will need to
download the