Threesuns

Email the Instructor

Contact

All Semesters

Semesters

All Courses

Courses

2010Spring

01.11.10 - 05.09.10

Database Design (Online)

CSYS2643

Online
12:00 AM - 12:00 AM

Relationships

Lab06

Objective: To identify the relationships that exist between tables

pastdue

Submit Your Solution

Lab06

Requirements

Relationship diagram completed10 pts
Deletion rules are given10 pts
Degree of participation is given20 pts
Type of participation is given10 pts
Foreign keys are identified20 pts
Linking tables are identified30 pts
Total100 pts

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.