Answered step by step
Verified Expert Solution
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started