CSc 4710/6710 Homework Assignment 3
Spring 2001; Due: February 13, 2001
-----------------------------------

(1) Solve problems 2.4 and 2.7 on pages 89-91 of the Oracle8 Primer
    textbook.

Remarks:

  - Data for the gradebook will be supplied later by me. For now, please
    use your own data; however final submission should be done with
    my data.

  - This homework will be electronically submitted. You need to perform
    a screen capture of the SQL session. Instructions on how to do the
    screen capture is given in the course Web page.

  - For problem 2.7, you must treat each update problem as operating
    on the same database, the one I give you. So, prior to each update,
    you should flush the database and repopulate with original data.

  - You must create 7 different .sql files called 24.sql, 27a.sql, 27b.sql,
    27c.sql, 27d.sql, 27e.sql, and 27f.sql. 
    The 24.sql file should contain all queries one after the other.

    The 27a.sql, 27b.sql etc files should contain your solution to the 
    corresponding update problem. Each update statement should be 
    preceded with a query or queries showing that part of the database state
    being affected by the update, and followed by a query or queries showing 
    that part of the database state which the update affected. 

  - CSc 4710 students will submit all 7 files using the handin command:

      $ handin4710 3 24.sql 24a.sql ...

    CSc 4710 students will submit all 7 files using the handin command:

      $ handin6710 3 24.sql 24a.sql ...