Homework 3
CS422, Fall 2010

Due: Wednesday, October 27

Please upload your solutions to CSNS. Note that file uploading will be disabled automatically after 11:59PM of the due date, so please turn in your work on time.

(40pt) Write triggers to enforce the following data constraints in the sample database University (university-create.sql, university-drop.sql).

For this exercises please submit two SQL scripts: hw3-triggers.sql and hw3-drop.sql. hw3-triggers.sql should include the code to create the triggers, as well as some insert statements to test whether the triggers work properly. hw3-drop.sql should include statements to remove the triggers and the associated functions.