Relationships

100 points

Relationships

Requirements

Relationship diagram completed10
The type of relationship and/or degree of participation is given20
Deletion rules are given10
Type of participation is given10
Foreign keys are identified20
Many to Many relationships are dissolved and linking tables are identified (in ERD, Final Table List, and in Field Specs)30
Total100 pts

Resources

Objective

To identify the relationships that exist between tables

Instructions

Create a relationship diagram for all of the tables in your database. In this table define a deletion rule for each relationship and identify the type and degree of participation in the relationship.

Identify foreign keys (FK) in your tables when relationships are formed.

During this process, if any linking tables are needed, add them to your diagram and return to the previous labs and complete all previous work for these new tables.