Exercise 1

• How to Do Exercise 1
• Submission Details

• Marking Scheme

• Some Statistics

Submission Details

Exercise 1 is to be submitted in your Lab Session in Week 2.

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

submit comp2400 ex1 q1.sql

OR

submit comp6240 ex1 q1.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 2.

[Top]

How to Do Exercise 1

1. Create a file called  q1.sql.

2. Place your code for the first query on the Queries against the SQL, Bugs, and Rock 'n' Roll Database lab worksheet in your  q1.sql  file
   (remembering to terminate the query with either  ;  or  /).

   Do not put any other queries in your  q1.sql  file.

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

4. Submit your  q1.sql  file (see above).

   Do not attempt to submit your  q1.sql  file at an SQL prompt.

[Top]