ASSIGNMENT #4
                                        -------------

                                 Due Wednesday, May 10, 2000


        1.   Give SQL data definitions for the  suppliers-parts-projects  database  of
             Assignment  #3.  Implement these in Oracle and build the necessary tables
             to contain the same data as in Assignment #3.

        2.   For the suppliers-parts-projects database, write the following queries in
             SQL. Validate the correctness of your answers using Oracle.

             a) Compute the parts supplied by a supplier in London  to  a  project  in
                London.

             b) Compute the suppliers which supply at least one part that is  supplied
                by at least one supplier who supplies at least one red part.

             c) Compute the suppliers with status lower than the  status  of  supplier
                S1.

             d) Compute the suppliers which supply exactly the same set of parts each.

             e) Compute the total quantity of parts supplied to each city.

             f) Change the color of all red parts to orange.

             g) Delete all projects for which there are no shipments.

             h) Insert a new supplier (S10) into relation S. The name, city and status
                are Smith, New York, and 40, respectively.