Homework VI

Tom Kelliher, CS 318

Due Apr. 17, 2002

1. 9.8. Your trigger's stored procedure code should be written in PL/pgSQL. Turn in the SQL you used to create the trigger and the stored procedure along with a small demo (using psql) of your trigger acting on the two brokerage firm tables (create on your own).

2. 10.2.

3. 10.3.a.

4. 10.4. At least three advantages and at least one disadvantage.