This preview shows page 1. Sign up to view the full content.
Unformatted text preview: • For each LEG instance, the airplane used in the leg, the number of available seats and the actual arrival and departure times and airports and kept. Write the following queries in relational algebra: (i) Retrieve the number of available seats and the leg number for flight number 'NY197' on '01-Mar-93'. (ii) For each flight, list the flight number, the departure airport for the first leg of the flight and the arrival airport for the last leg of the flight. (iii) List the flight numbers and weekdays of all flights or flight legs that depart from New York International Airport (airport code 'IANY') and arrive in London International Airport (airport code 'IALD'). (iv) List the flight number and weekdays of all flights or flight legs that depart from some...
View Full Document
This note was uploaded on 02/06/2012 for the course FACULTY OF WXGE6320 taught by Professor Noraini during the Winter '09 term at University of Malaya.
- Winter '09