Computer Science 455

Second Exercise Set

Due: Wednesday, Feb. 10.

Write EASYALG statements for the following queries:

1. Find full details of all projects in London.
2. Get supplier number values for suppliers who supply project J1
3. Get JNAME values for projects supplied by supplier S1
4. Get supplier number values for suppliers who supply project J1 with a red part
5. Get supplier name values for suppliers who supply a London project with a red part

Place these in a file called EASYALG.COM in your root directory on the VAX. The command file EASYALG.com should have the following format:

$set verify
$!
$!  Your Name Here
$!
$run easyalg
LOAD SPJ.DB
SELECT <-- statements for the first question
 
PRINT ANS1 <-- please do exercises in order,
       calling (and printing) your results
       as ANS1, ANS2, etc.
 
EXIT
 

Any questions? Please let me know. Many thanks!