Assignment #4 ComS 461/561 Due December 2, 2009

1) Use Hibernate to create an object based database for the data given in Assignment #1. The database should support 3 classes: Instructor, Department, and Course.

2) Use the data given in Assignment #2 part a) to modify the database you created in part 1). Use a second program to accomplish this.

3) Use Hibernate HQL to query your database to determine the list of names and addresses of instructors that work in the ComS department.

4) Use Hibernate to change the address of instructor 1030 to reflect that she has moved to Ames,Ia.

5) Use Hibernate to remove instructors 1040 and 1050 from the database.

6) Use Hibernate HQL to query your database to determine the list of names and addresses of instructors that work in the ComS department. Note that this is the same query as in 3), but the data should be different.

7) Use Hibernate HQL to query your database to determine the list of names and addresses of instructors that work in Ames.  Note that the state is missing so you will need to use the wild card.

You can use one or five programs to implement parts 3) through 7).

Please hand in a printed copy of your Java code, and a printed copy of the results of parts 3, 6 and 7.