Exercise 4

• How to Do Exercise 4
• Submission Details

• Marking Scheme

Submission Details

Exercise 4 is to be submitted in Week 8.

The command to use (on a unix command line) is:

submit comp2400 ex4 qmax.sql

OR

submit comp6240 ex4 qmax.sql

(depending upon which course you are enrolled in).

If you have trouble submitting your file , ask your tutor for assistance during your Lab Session in Week 8.

[Top]

How to Do Exercise 4

Your task for this Exercise is to create a query using the sql function  max. Your query will run aginst tables in the SQL, Bugs, and Rock 'n' Roll Database

1. Copy and save the supplied code as  qmax.sql  in an appropriate folder in your student home directory.

2. Update your  qmax.sql  by replacing each  <description>  with appropriate text.

   Do not put any other commands in your  qmax.sql  file.
   Do not put any other comments in your  qmax.sql  file.

3. After making sure that you are in the correct directory, test your  qmax.sql  by starting it at an SQL prompt.

4. Submit your updated copy of  qmax.sql  (see above).

[Top]