1.Start SQL*Plus

2.Write and execute SQL for the following queries. Save each successful commands in file. Note that the commands use the following tables:

Airport(Airport, AName, CheckIN, Resvtns, FlightInfo)

Route(RouteNo, RDescription)

Fares(FareType, Fdescription, Conditions)

Tariff(RouteNo , FareType, Price)

Aircraft(AircraftType, ADescription, NoSeats)

Flight(FlightNo, FromAirport, ToAirport, DepTime, ArrTime, Service, AircraftType, RouteNo)

Passenger(Pid, Name, Address, TelNo)

Ticket(TicketNo, TicketDate, PID)

Itinerary(TicketNo, FlightNo, LegNo, FlightDate, FareType)

3.For each flight with the aircraft capacity of at least 100 seats, list the flight number, the aircraft description, the departure airport and the arrival airport.

4.From the itinerary information, find the flight numbers and the dates for the flights that depart from Coventry.

5.List the names of the airports in alphabetical order which can accommodate landing aircraft of type ATP.

6.Find the prices of all tickets issued on 11/08/2004.

7.List the code of those airports that do not have any flights with scheduled departure time between 1:00 am (0100) and 7:30am (0730).

8.List the names of the passengers with at least two tickets which cost over 180 each.