Homework #4, CSc 498/698, Spring 1998


(1) Write and run an embedded-SQL program which shows the following menu:

    (a) Find supervisees at all levels
    (q) Quit
    
    Please enter your choice: 

When the user chooses option (a) the program should prompt for the last name 
of an employee. If the name is not unique, the program should list the SSN
numbers of all the employees with the same last name and ask the user
to choose from the list.  The program should then compute and print the 
ssn and names of all employees who work under the given employee at all levels. 
After this the program should display the menu again.


(2) (GRADUATE CREDIT) Write and run an embedded-SQL program which produces 

    (a) A listing of the 5 highest paid employees in the company. 
        The listing should contain ssn, name and salary.

    (b) A listing of the 5 most worked employees (in terms of hours) 
        in the company. The listing should contain ssn, name and total
        hours worked.


For both the programs, you must use the csc498 database.

Note: If you are doing both problems, you may choose to write just
one program and have menu options for both problems.