Computer Science 455

Fifth Exercise Set

Due: Friday, March 31. Please note that these problems are good review for the second hour exam on Monday, March 27.

Recall the "Hoh River College" database created in an earlier exercise with the following tables:

• student: table of students
• faculty: table of faculty
• class: table of classes offered by the Hoh River College
• teaches: association table between faculty and classes
• enroll: association table between students and classes (with a numeric grade)

With respect to this database, do the following:

• Pick a student enrolled in classes and remove the student from the database together with the enrollment records associated with the student. Verify that the deletions worked correctly.
• Add a new student to the database (to an existing advisor), and register the student for three courses. Verify that the insertions worked correctly.
• Pick a class, and raise the grades of everyone in the class by 0.1. Verify that the change has been made correctly. (Verification on this and other problems can be accomplished with the appropriate before and after SQL statements).
• Pick a class and produce a report of the class, giving all appropriate information (name of class, name and number of teacher, names and numbers of students in the class, student grades, total number of students and average class GPA).
• Create an enrollment form which will accept a student ID, fill in the name of the student's advisor, and permit registration for up to five courses. Include 'commit' and 'clear form' buttons. Include verification that the form works correctly.

Papers should be stapled in order, with the name(s) of those working on the exercise. Group work on this project is encouraged. If you do work as a group, please turn in only one document (with the names of everyone in the group who participated). Each group should decide on an Oracle account belonging to one member of the group to work in, and everyone in the group should know the password for that account (the account will need to be shared for several exercises). If a project group works together on this exercise, using the group account would be fine. It is not required, of course, that you divide up into project groups. Work should be turned in during class on Friday, March 31.

Any questions? Please let me know. Many thanks!