This is the end of lab # 2 # 4.--------------------------------------------------------------------------------------- CIS 336 iLab 3 Building the Physical
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.
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 # 4.--------------------------------------------------------------------------------------- CIS 336 iLab 3 Building the Physical