EEN523 Second Assignment

Due Thursday 18th February 1999


        Write a program that presents a moderately user-friendly interface to the example database. You should think of a few kinds of queries that people would be likely to want to ask of an airline's database, and give them a way of asking those queries that does not require any expertise or knowledge of databases at all. The interface does not have to be pretty or even nice, just simple.

Perhaps (but this is only a hint to get you going) it could offer a menu of query types:
    Select one from:
  1. To find personal details for a particular person,
  2. To find all locations visited by a particular person,
  3. To find all flights to a particular location,
  4. etc. etc. etc.
Then if the user enters 2, it would ask for the person's name (first, last, both, whatever), construct the appropriate query, submit it to the database server, receive the results, and display them in an understandable form.

There is no need for anything fancy, just a reasonable working interface between an ignorant user and the big system.