You will modify your movie database in ways that probe some additional integrity-constraint issues.
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.)
Modify both your E-R model and your SQL create table
and select
statements to accommodate the following two new
requirements.
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.