MCS-274 Lab 2 (Spring 2005)


You will modify your movie database in ways that probe some additional integrity-constraint issues.

Foreign key triggers

In the previous lab, your create table statements should have included some foreign key constraints. If not, add them now. You might, however, have left out the triggers that specify what should be done on deletions and updates. Decide what the right actions are and add the on delete and on update triggers, unless you already had them in lab 1. (In the the latter case, your report should show again what you had.)

Additional requirements

Modify both your E-R model and your SQL create table and select statements to accommodate the following two new requirements.

Lab report

Write a report that is concise and assumes an audience familiar with your assignment and the technology, but which addresses all the above topics in an organized fashion.

Instructor: Max Hailperin <>