A fun in-class exercise...

Design a data model for an airline reservation system.

You want to be able to answer the following questions:

1) What are all the flights from BOS to SFO tomorrow?

2) What are all the flights from BOS to SFO tomorrow that have at least
   one seat available?

3) Is flight 237 a week from today full?

4) What are the names of all the passengers on flight 237 a week from today?

5) How many flights has John Q. Salaryman taken within the last 12
   months?

Please sketch your data model, with at least every table defined and the
critical columns defined, and write out SQL queries to answer these
questions.  Email the data model/queries to philg@mit.edu so that I can
prepare a slide/handout for discussion in class on Thursday (February
23).  This is a team assignment, so don't work on it alone!

Thanks.