Determine airports with late flights to toronto-database

Assignment Help Database Management System

Reference no: EM1372165

The database schema is as follows:

AIRPORT(city, country, runways); (the last attribute is the number of runways at an airport)
FLIGHT (flightID, day, depart_city, arrive_city, depart_time, arrive_time, plane_type)
PLANE(plane_type, capacity)

Write following queries in SQL and relational algebra:

1) Find the airports with a direct flight to Toronto
2) Find airports with late flights to Toronto on a big plane. "Late" means departing after 9:00pm; "big" means with capacity 150 passengers or more
3) Find cities from which one can fly to Toronto with one change of planes, and using the same type of the aircraft for both legs of the trip.
Write following queries in SQL and relational algebra.
1) Find flight numbers of flights that use a small (capacity less than 50) plane
2) Find all airports with at least 3 runways that have 2 or more flights to Paris a day, or with capacity at least 250.
Assumption: (flightId, day) pairs are unique (i.e., there are no two flights with the same flightId on the same day).

Reference no: EM1372165

Questions Cloud

Write a counter-culture essay : Write a working thesis that defines the counterculture as distinct from the dominant or mainstream culture of its time and find a scholarly article that analyzes your proposed counterculture, provide its MLA citation, and summarize its thesis.

Identifying the level of output : Given output and Total Cost information in the Table below, Complete the following columns: Fixed Costs, marginal Cost, Variable cost, Average Total Cost columns.

Popular literature-harry potter series : Recognize the literary production you chose to focus on. Provide the brief overview of what the piece is about, the author's background and how the piece fits or does not fit with other literature of that genre.

What type of costing method would this auto body repair : each job this auto body repair shop handles is a special order job. What type of costing method would this auto body repair shop most likely use.

Determine airports with late flights to toronto-database : Determine airports with late flights to Toronto on a big plane. "Late" means departing after 9:00pm; "big" means with capacity 150 passengers or more

Determine the optimal price of product : After a 10 percent price discount, a company found that its weekly sales increased by 30 percent. If the marginal cost (MC) of this product is $40 each, determine the optimal price for this product?

Estimating profit : Your supervisor recently instituted a plan that encourages her managers to share non private demographic characteristics voluntarily provided by those who buy your company's final product.

How can a firm gain by reducing competition : Price higher in monopoly market. Bigger quantity in perfect competition. How can a firm gain by reducing competition.

How did this impact competition in many markets : f P falls below AC, what is result for firm? Firm loses money 16. In late-19th century, both firms and markets expanded. How did this impact competition in many markets.

User Account

All Pages