Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the database with single relation FLIGHTFARES that records the fares of nonstop flights from one city A to another city B by various airlines.

image text in transcribed

image text in transcribed

Consider the database with single relation FLIGHTFARES that records the fares of nonstop flights from one city A to another city B by various airlines. Note that the flights from city B to city A are independent from the flights from A to B. For example: FLIGHTFARES: ToCity Memphis Memphis FareAirline FromCity San Francisco San Francisco Memphis Memphis Memphis Chicago Memphis Memphis San Francisco San Francisco New York San Francisco New York Americarn United United American Jet Blue Delta Delta American United United United Jet Blue United 300 350 San Francisco 250 San Francisco 250 250 Chicago New York New York New York New York Chicago Chicago Chicago San Francisco 500 400 0 650 0 Implement the database using a DBMS of your choice, including: [a] SQL query that returns the cost of the cheapest nonstop flight or flights between each pair of the cities. Show the result for the instance data above. [b] SQL query that returns the cost of the cheapest cost and flights for traveling between each pair of cities a customer is willing to stop once en-route. Show the result for the instance data above. Identify the DBMS and show the SQL code used

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

Formal SQL Tuning For Oracle Databases Practical Efficiency Efficient Practice

Authors: Leonid Nossov ,Hanno Ernst ,Victor Chupis

1st Edition

3662570564, 978-3662570562

More Books

Students also viewed these Databases questions

Question

Describe the job youd like to be doing five years from now.

Answered: 1 week ago

Question

So what disadvantages have you witnessed? (specific)

Answered: 1 week ago