4 Aug 2000

Due:  11 Aug 2000
------------------------------------

Create tables with following schema :

S ( sno, sname, status, city )
P ( pno, pname, colour, weight, city )
J ( jno, jname, city )
SPJ( sno, pno, jno, qty )

Insert some sample data into the tables and execute the following queries:

1. Get all supplier number, part number, and project number triples such that
indicated supplier, part and project are all colocated.

2. Get all supplier number, part number, and project number triples such that
indicated supplier, part and project are not all colocated.

3. Get the triple such that no two of the indicated supplier part and project 
are colocated.

4. Get part numbers for parts supplied to any project in London.

5. Get all pairs of parts, part number such that some supplier supplies both 
the indicated parts.

6. Get project names for project supplied by supplier `S1'.

7. Get colours of part supplied by `S1'.

8. Get project number for projects using atleast one part available from 
supplier `S1'.

9. Get all cities in which atleast one supplier, part or project is located.