Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DB2 Universal Database V7.1 Application Development Certification Guide

Authors: Steve Sanyal, David Martineau, Kevin Gashyna, Michael Kyprianou

1st Edition

0130913677, 978-0130913678

More Books

Students also viewed these Databases questions

Question

Evaluate the importance of diversity in the workforce.

Answered: 1 week ago

Question

Identify the legal standards of the recruitment process.

Answered: 1 week ago