Database Systems: Design, Implementation, and Management, 12th Edition (Database Book)

ISBN -13: 978130562748-2

EXERCISES ON RELATIONAL ALGEBRA

Use the following schema to write relational algebra statements for the questions that follow. The primary keys are underlined in the schema.

Pilot (pid: integer, pname: char, salary: integer)

Aircraft (aid: integer, aname: char, cruisingrange: integer)

Flight (flightno: integer, aid: integer, pid: integer, day: date)

1. Find the names of pilots who use the aircraft (aname) Boeing 727.

2. Find the id and name of the pilot who operated flightno CO103 on 01/01/99 with a cruising range of 3000 miles.

3. Find the cruising range of the aircraft operated by Jeffery Jones on 12/23/97.

4. Find the ids and names of pilots who can operate aircrafts with a range greater than 5000 miles with salaries more than $100,000.

5. List all the flights on 02/22/98.

6. List all the pilots.

7. Find the names pilots who operate of aircrafts with a cruising range between 4000 miles and 6000 miles.

8. List the id and name of the aircraft used for flightno NW111.

9. List all the Boeing 757 (aname) aircrafts.

10. Find the names of all pilots who receive a salary greater than $150,000.