Reference no: EM13934301
The following relations keep track of airline flight information: Flights(flno: integer, from: string, to: string, distance: integer, departs: time, arrives: time, price: integer) Aircraft(aid: integer, aname: string, cruisingrange: integer) Certified(eid: integer, aid: integer)
Employees(eid: integer, ename: string, salary: integer)
Note that the Employees relation describes pilots and other kinds of employees as well; every pilot is certified for some aircraft, and only pilots are certified to fly. Write each of the following queries in SQL.
1. Find the names of aircraft such that all pilots certified to operate them earn more than 80,000.
2. For each pilot who is certified for more than three aircraft, find the eid and the maximum cruisingrange of the aircraft that he (or she) is certified for.
3. Find the names of pilots whose salary is less than the price of the cheapest route from Los Angeles to Honolulu.
4. For all aircraft with cruisingrange over 1,000 miles, find the name of the aircraft and the average salary of all pilots certified for this aircraft.
5. Find the names of pilots certified for some Boeing aircraft.
6. Find the aids of all aircraft that can be used on routes from Los Angeles to Chicago.
7. Identify the routes that can be piloted by every pilot who makes more than $100,000.
8. Print the enames of pilots who can operate planes with cruisingrange greater than 3,000 miles, but are not certified on any Boeing aircraft.
9. A customer wants to travel from Madison to New York with no more than two changes of flight. List the choice of departure times from Madison if the customer wants to arrive in New York by 6 p.m.
10. Compute the difference between the average salary of a pilot and the average salary of all employees (including pilots).
11. Print the name and salary of every nonpilot whose salary is more than the average salary for pilots.
|
Find names of all students who are enrolled in two classes
: Find the names of all students who are enrolled in two classes that meet at the same time. Find the names of faculty members who teach in every room in which some class is taught.
|
|
Determine the force exerted by the deltoid muscle
: Determine the force exerted by the deltoid muscle on the upper arm at A and the x- and y-components of the force reaction at the shoulder joint O
|
|
Compare and contrast reversal treatment designs
: Compare and contrast reversal treatment designs. What advantages or disadvantages exist for these two designs? Taking into consideration the strengths, limitations, and appropriateness of each design, which, in your supported opinion, is superior ..
|
|
Discuss the various logistical issues
: Discuss the various logistical issues you would have to consider before commencing the import of products from the two new factories, taking into account the various procedures that need to be considered, the modes of transport you may need to use..
|
|
Find the aids of all aircraft that can be used on routes
: Find the aids of all aircraft that can be used on routes from Los Angeles to Chicago. Identify the routes that can be piloted by every pilot who makes more than $100,000.
|
|
Interfaces between logistics and the core functional areas
: Assignment Brief: Select a manufacturer that you are familiar with and assume that you are the logistics manager of this organization, analyse the interfaces between logistics and the core functional areas, its current order cycle, and inventory ..
|
|
Implementation of lean
: You are asked to provide a critical discussion on the implementation of lean which addresses the following questions: 1) Is there a best way to implement lean? 2) Are all organisations suitable for lean implementation?
|
|
Child development in the family context
: Select a toddler or preschool aged child aged between 2-5yrs who has a pattern of normal development and observ the child in the context of their family.
|
|
How leadership skills develop
: Discuss and support your position on whether leaders are born or made using current research. This discussion includes the following aspects:- A brief definition of leadership and How leaders are identified.
|