Database Design (Online)
3 credits
| Relationship diagram completed | 10 |
| Deletion rules are given | 10 |
| Degree of participation is given | 20 |
| Type of participation is given | 10 |
| Foreign keys are identified | 20 |
| Linking tables are identified | 30 |
| Total | 100 pts |
To identify the relationships that exist between tables
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.