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
Modify both your E-R model and your SQL
select statements to accommodate the following two new
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.