Exercise 5

• How to Do Exercise 5
• Submission Details

• Marking Scheme

Submission Details

Exercise 5 is to be submitted in Week 10.

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

submit comp2400 ex5 qparm.sql

OR

submit comp6240 ex5 qparm.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 10.

[Top]

How to Do Exercise 5

Your task for this Exercise is to create a query which uses one parameter (&1). Your query will run against tables in the SQL, Bugs, and Rock 'n' Roll Database

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

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

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

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

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

[Top]