Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Q1. In the given airline database schema: (Do any nine)

Flights(flno, from, to, distance, departs)
Aircraft(aid, aname, range)
Certified(eid, aid)
Employees(eid, ename, salary)

By definition, pilots are such employees who are certified on at least one aircraft. The aircraft can be used for any flight provided it has adequate range. Pilots can pilot any flight given they are certified on an aircraft with adequate range.

Problems:

a) Find out the eid’s of pilots who are certified on some Boeing.

b) Find out the names of pilots who are certified on some Boeing.

c) Find out the aid’s of aircraft which can fly non-stop from LA to NY. Suppose that you don’t already know the distance.

d) Find out the flno of flights which can be piloted by every pilot whose salary is over $100,000.

e) Solve the above problem without using the division operator.

f) Find out the names of pilots who can operate planes with a range more than 3,000 miles, however are not certified on any Boeing.

g) Find out eid of employee(s) with the maximum salary.

h) Find out the eid of employee(s) with the second maximum salary.

i) Find out the eid of employee(s) certified on the most aircraft.

j) Find out the eid’s of employees certified on precisely three aircraft.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M910854

Have any Question? 


Related Questions in DBMS

Create a small bank account database with one account table

Create a small Bank Account database with one Account table. The Account table Should have fields for account number, customer last and first names, and current balance. The type of database will be Access .Populate the ...

Computer sciencein reference to your database design

Computer Science In reference to your Database Design Proposal: Proposal Outline, provide a narrative analysis of the customer and user needs by defining the customers and users as well as describing their individual nee ...

Projectfalcor supplies is a distributor of high tech

Project Falcor Supplies is a distributor of high tech teaching equipment. Its primary target customers are schools in the region who purchase the teaching equipment for classrooms and online use. The company's main compe ...

Database design assignmentpart 1customer resource

Database Design Assignment Part 1 Customer Resource Management Database You have been tasked to develop a set of tables for a customer resource management database. You are required to store the following information in ...

A task descriptionoverviewyour task is to create and test a

A. Task Description Overview Your task is to create and test a database in MySQL using PhpMyAdmin. You are provided with a scenario and supporting documents, describing the requirements that Southern Cross University may ...

Mis 204 hands-on activityaccess - forms and

MIS 204 Hands-On Activity: Access - Forms and Reports Introduction In this assignment you will learn how to create forms and reports to access and analyze your data. Forms are useful for data entry and navigation. Report ...

At this point you decide to implement a hash structure for

At this point, you decide to implement a Hash structure for the contributor data to prepare for searches. You will read the contributor information from a file provided; it is a comma delimited (CSV) file. As each record ...

Some people used to believe that data warehouses would

Some people used to believe that data warehouses would quickly replace databases for both online transaction processing (OLTP) and online analytical processing (OLAP). Of course, they were wrong. Why can data warehouses ...

Career opportunities in your majorknowledge workers

CAREER OPPORTUNITIES IN YOUR MAJOR Knowledge workers throughout the business world are building their own desktop databases (often called end-user databases or knowledge worker databases). To do so, they must understand ...

Oracle erp systemsoracle provides erp solutions for

Oracle ERP Systems Oracle provides ERP solutions for mid-size business organizations. For this assignment, you are to write a research report on these ERP solutions. Your report should include: • a description of Oracle ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen