Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following relations keep track of airline flight information: Flights ( flno: integer, origin: string, destination: string, distance: integer, departs: time, arrives: time, price: real

The following relations keep track of airline flight information:
Flights (flno: integer, origin: string, destination: string, distance: integer, departs: time, arrives: time, price: real)
Aircraft (aid: integer, aname: string, cruisingrange: integer)
Certified (eid: integeri, aid: integer)
Employees (eid: integer, ename: string, salary: integer)
Identify the routes that can be piloted by every pilot who makes more than $70,000.(In other words, find the routes with distance less than the least cruising range of aircrafts driven by pilots who make more than $70,000)

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

Step: 3

blur-text-image

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

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Databases questions