ASSIGNMENT #5
                                        -------------

                                 Due Wednesday, May 24, 2000


        Write a nontrivial Java program with JDBC to perform operations  on  your  SPJ
        database.  The  program should illustrate a feature or features that cannot be
        done conveniently in pure SQL.  You are encouraged to be imaginative. However,
        here  are  some  sorts of things you might try if you can't think of something
        more interesting:

        a) Compute some aggregate value from a relation and use that value  to  modify
           values in that or another relation.

        b) Create a new relation and load it with values computed  from  one  or  more
           existing  relations,  e.g.  like a transitive closure of a graph that would
           ordinarily require recursive rules.

        c) Enforce a constraint by searching your database for violations  and  fixing
           them in some way.

        d) Provide for data entry using a Java applet.

        e) Construct a complex object from the relational tables, e.g. a single object
           for  the  entire  database  that  can be navigated in starting from various
           entry points.

        Hand in a listing of your program and scripts (or snapshots  in  the  case  of
        applets)  showing it working. The program should be clearly documented showing
        what it is doing. You should demonstrate that the  program  has  its  intended
        effect  by querying (before and after) some relation of your database that was
        changed by the program. These queries may be included in the file  that  holds
        your Java programs for convenience.