Find the aids of all aircraft that can be used on routes

Assignment Help Database Management System
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.

Reference no: EM13934301

Questions Cloud

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.

Reviews

Write a Review

 

Database Management System Questions & Answers

  Imagine that you work for a consulting firm that offers

imagine that you work for a consulting firm that offers information technology and database services. part of its core

  Data protection and security

Discuss ways that the IT organization can counter the negative impacts of social networking. Explain how the IT organization can maintain an ethical posture while managing organizational behavior related to social networking.

  Imagine that you have been hired as the database

imagine that you have been hired as the database administrator for a local department store. the department store has

  List all the functional dependencies present in the relation

You must implement the entity relationship model provided in the model solution to Assignment 1. The model solution will be released on the course website approximately TWO (2) weeks after the Assignment 1 due date.

  Write name of employee on every project located in houston

Write the name(s) of employee(s) who works(work) on every project located in Houston. Write the name(s) of employee(s) who only works(work) on every project located in 'Houston.'

  Question 1explain ten desirable features which may be

question 1explain ten desirable features which may be included in the design of a warehouse. question 2how have to a

  Discuss the relationship between colossal and core patterns

Discuss the relationship between colossal and core patterns. What is boosting? State why it may improve the accuracy of decision tree induction? Ensemble methods improve classification accuracy. How?

  Define conceptual design

Water meters must be replaced when they have been in use for 5 years. We can assume that a meter will never be damaged or become unserviceable and will not be re-assigned to another service address.

  Provide a description of relationships between organisation

Discuss how this organisation has responded to the introduction of Information Systems (IS) into their business paradigms. Highlight the advantages of IS, the disadvantages and the resultant shortfalls that must be addressed in this organisation.

  Describe the results and your analysis and observations

In a word document, describe the results and your analysis and observations. Discuss any analysis techniques you performed and their results to support the differences (or similarities) you discovered

  Which is not a factor to consider in software evaluation

Which is not a factor to consider in software evaluation?

  Part ause the prime minister database primeminister2013sql

part ause the prime minister database primeminister2013.sql available from the interact site. answer the following

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd