Computer Science 455

Second Exercise Set

Due: Wednesday, Feb. 11.

Write SQL statements for the following queries:

1. Find full details of all projects in London (just information from the J table).
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

The command file should have the following format:

set echo on

/*
     your name
*/

/*
     Find full details of all projects in London
*/
select ... etc.

/*
     Get supplier number values for suppliers
     who supply project J1
*/
select .... etc.

     .
     .
     .


exit

 

Turn in (in class on Wednesday) a printout of what happens when the command file is run (use the SPOOL command in SQL PLUS). 

Any questions? Please let me know. Many thanks!