Question
Start SQL*Plus, Write and execute SQL for the following queries. Save each successful commands in file. Note that the commands use the following tables: Airport(Airport,
Start SQL*Plus, 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)
q1?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).
q2?List the names of the passengers with at least two tickets which cost over 180 each.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started