Tutorial 4Ans - Exercise II 1.Consider the following...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Exercise II 1.Consider the following AIRLINE database schema that describes the database for airline flight information: AIRPORT (Airport-code , Name, City) FLIGHT (Number , Airline, Weekdays) FLIGHT_LEG (Flight-number , Leg-number , Departure-airport-code Scheduled-departure-time, Arrival-airport-code, Scheduled-arrival-time) LEG_INSTANCE (Flight-number , Leg-number , Date, Number-of-available-seats, Airplane-id) Assume the following set of requirements: An AIRPORT is identified by an Airport-code. Each FLIGHT is identified by a Flight-number and consists of one or more FLIGHT_LEGs with leg-number being 1, 2, 3, etc. Weekdays (e.g. Monday, Tuesdays, etc.) are also recorded with each FLIGHT. Each leg has scheduled arrival and departure times and airports. It has also many LEG_INSTANCEs - one for each Date on which the flight travels. 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:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the 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.

Page1 / 2

Tutorial 4Ans - Exercise II 1.Consider the following...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online