Computer Science 455

First Exercise Set

Due: Wednesday, Feb. 4 (in class)

Write EASYALG statements for the following queries:

1. Find full details of all projects in London. (select on J only)
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

Turn in a listing of the solutions. Preface each solution by the problem it solves (for example, "Find full details of all projects in LONDON"), and have a PRINT ANS as the last line in each problem solution (so I can check your solution).

Any questions? Please let me know. Many thanks!