CS 311: Databases

Constraints and Queries for your Project
(Homework 8)

due on April 24

This is the fourth of five assignments for our semester-long project.

There are two parts to this assignment. For the first part you are to create one Check constraint and one Trigger. These should be reasonable constraints to put on your databases. Fore example, the Check constraint might enforce a natural domain constraint for your data. The trigger might update an otherwise non-updatable view (by modifying its base tables). You might also use the trigger to prevent undesirable updates, such as removing any insertions with improper values. Try to use the trigger to do something you couldn't otherwise do.

The second part of the assignment is to make a list of 8 natural queries for your database. For each query I would like a comment that says in English what the query is looking for, then the SQL code for the query.

Put all of this in one SQL file (with name "foobar.sql") and submit it via handins by the end of Monday, April 24.