Due: June 22, 1999 (Tuesday)

Note that the due date of this homework has been extended from June 17 to June 22.  Homework #3 will still be due on June 24 (Thursday).

For the project Web-Based Work Request System as described in Homework #1:

(1)  Implement the Rational Rose's suggested solution of Homework #1 in the relational model by showing the relations, their primary keys, candidate keys and foreign keys.  For each foreign key, mention whether the null value is acceptable or not.

(2)  Re-do your design in Oracle's Designer 2000 all the way to SQL generation.

Turn in a hard copy of your work (including the ER diagram and the SQL code generated by Designer 2000).  Include your name and your Oracle account name.