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?