Flight+Bookings

Open the database Flight Bookings. Now answer the question below.


 * 1) The database contains 2 tables. What are the names of these tables?
 * 2) What are the primary keys in each table?

Answer the following questions by a) Stating which search you will perform e.g. Name = Smith AND Age > 40  b) Performing the search and noting the answers
 * 1) Name the passengers who have a Gold loyalty card within the EH postcode district.
 * 2) A customer called Cartright, flying from Edinburgh, has called to find out his flight number. What is it?
 * 3) David Smith is flying to Madrid and has phoned in to find out his flight number. What is it?
 * 4) A survey shows that passengers prefer to make a maximum of one stop. How many passengers are going on a flight which has more than 1 stop?
 * 5) Head Office have requested statistics on the number of passengers who do not have a loyalty card.