Computer Science 455
Exercise set #7
Due:  Monday, April 26

I. SQL exercises

In the file SQL04.SQL in the root directory of your class account,
write queries as follows.  Please be sure to have your name in
the header documentation in the file, and to include the text 
of each question before the corresponding SQL query.  Finally,
be sure to have

	set echo on

as the first line of your file.

The following exercises are copied from Date, Third Edition, chapter 7, pp 141 - 142:

1. 	Get the part number for parts such that no 
	other part has a smaller weight value.
2. 	Get JNO values for projects not supplied with any 
	red part by any London supplier.
3 Get SNO values for suppliers supplying at least 
	one part supplied by at least one 	
	supplier who supplies at least one red part.
4. Get SNO values for supplers who supply the 
	same part to all projects.
5.	Get JNO values for projects supplied entirely by supplier S1.
6.	Get PNO values for parts supplied to all projects in London.
7. 	Get JNO values for projects supplied with at least all parts  
	supplied by supplier S2.
8. 	Get JNO values for projects which use only parts  
	which are available from supplier S1.
9. 	Get JNO values for projects supplied by supplier S1 
	with all parts that supplier S1 supplies.
10. 	Get JNO values for projects supplied by all suppliers 
	who supply some red part.
11.	Get the total number of projects supplied by supplier S3.
12.	Get the total quantity of part P1 supplied by supplier S1.
13. 	For each part being supplied to a project, get the 
	part number, the project number, the corresponding total quantity.


II. Algebra queries

In your root directory place a command file called algebra.com 
with relational algebra queries for the following.  Your command file
should begin with $set verify and include documentation giving your
name.

1.	Get sno values for suppliers who supply project J1 with part P1.
2.	Get JNAME values for projects supplied by  supplier S1.
3. 	Get SNAME values for suppliers who supply both projects J1 and J2.
4. 	Get SNO values for suppliers who supply project J1 with a red part.
5. 	Get SNO values for suppliers who supply a London 
	or Paris project with a red part.
6. 	Get SNO values for suppliers who supply both London 
	and Paris projects with a red part.
7. 	Get SNO values for supplers who supply the same part to all projects.
8. 	Get JNO values for projects supplied with at least all parts  
	supplied by supplier S2.