Assignment	Sample Solutions
Assignment1	Assignment1 tentative solution
Assignment2  DB2 information	Test Data Expected results
Assignment 3 The database schema is here. Due date: August 5, 2005, 5pm CLARIFICATIONS: 1.3 query1: the program has to return a list of employee names 2.3 trigger3: After an update is made on attribute budget of table project, the trigger will generate an action only if the project whose budget(cost) is updated is a base project. ERRATA 2.2 trigger2 : "Write a trigger named trigger2 that will check before a delete is made on the table worksFor" should read "Write a trigger named trigger2 that will check before a delete is made on the table worksOn"