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