A1Ans - - 1- Spring 2009 University of Waterloo School of...

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

View Full Document Right Arrow Icon
- 1 - University of Waterloo School of Computer Science CS338 Spring 2009 Assignment 1 Due: May 26, 2009 Suppose that we informally define data in a database for an airline application as follows. Information stored includes data about flights, airplanes, passengers and flight crews. (a) For each airplane, its registration number, type and capacity (i.e., maximum number of passengers) are recorded. Each plane has a unique registration number. Each plane is assigned to at most one flight at any time. (b) For each flight, its flight number, departure date, departure airport, departure time, destination airport, arrival date and arrival time. A flight is uniquely identified by its flight number and its departure date. A flight may consist of one or more legs. For each leg of a flight, the departure airport, departure date, departure time, arrival airport, arrival date and arrival time are recorded. For each flight, we also need to record which pilots and which flight attendants have been assigned to the flight. For simplicity, we assume that the flight crew is unchanged for
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.

Page1 / 2

A1Ans - - 1- Spring 2009 University of Waterloo School of...

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