Question: Use the ERD diagram provided to output the following table on Oracle SQL Developer using both of the following criteria... Both A & B should

Use the ERD diagram provided to output the following table on Oracle SQL Developer using both of the following criteria... Both A & B should have the same output.

a) Using a SUB QUERY, display the flight number, originating airport, destination airport, departure time as "Departure Time", and arrival time as "Arrival Time" for flights not departing on May 17, 2017.

b) Using a SET OPERATION, display the flight number, originating airport, destination airport, departure time as "Departure Time", and arrival time as "Arrival Time" for flights not departing on May 17, 2017.

1 2 3 4 56789 10 H23 H4 9 9 272 2 11 12 13 14 15 16 17 18 19 20 21 23 FL_FLIGHT_NO FL_ORIG FL_DEST Departure Flight Reservation Schema - Entity Relationship Diagram PAS ITINERARY NO PAS NAME PAS FARE NUMBER PAS

1 2 3 4 56789 10 H23 H4 9 9 272 2 11 12 13 14 15 16 17 18 19 20 21 23 FL_FLIGHT_NO FL_ORIG | FL_DEST Departure Time LAX LAX PHX SFO PHX MSP PHX FLG SFO LAX PHX PHX DEW IAH JFK IAH PHX DTW SFO SFO PHX JFK PHX 15 PHX 40 PHX 59 SFO 60 PHX 101 FLG 102 PHX 103 MSP 104 PHX 198 LAX 298 PHX 329 LAX 400 LAX 500 IAH 501 DEW 502 IAH 503 JFK 518 SFO 521 IAH 600 PHX 604 PHX 691 SFO 723 DTW 1260 SFO 07:00 22:25 10:00 17:45 05:15 09:00 17:00 20:30 23:20 05:00 21:10 10:10 08:00 09:05 08:30 13:25 14:23 11:30 06:46 08:33 11:25 13:30 17:58 Arrival Time 07:20 22:42 11:30 18:36 06:20 13:00 19:15 21:15 01:40 05:30 23:59 12:59 08:55 10:00 12:30 15:30 16:16 13:30 07:50 09:43 13:04 16:05 19:51

Step by Step Solution

★★★★★

3.47 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Based on the ERD diagram and the data youve provided I will write two SQL queries for Oracle SQL Dev... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Lana and Vien Tran are purchasing a home for an agreed sales price of $ 1 5 9 , 1 5 0 . They have applied for an FHA loan with maximum financing. Making the 3 . 5 % down payment, then rolling in the...

According tonew researchby Harvard University researchers, Starbucks comes by its reputation as the bellwether of gentrification: When the coffee giant colonizes a neighborhood, home prices tend to...

A researcher wanted to find out if there was difference between older movie goers and younger movie goers with respect to their estimates of a successful actors income. The researcher first...

Explain how to apply the rules of Section (61)a to determine taxable items.

The Review Questions 7.3 to 7.40, from the Kroenke book starting page 357, have been duplicated below, to assist in the completion of this Lab Assignment. RQ Questions 7.1, 7.2 and 7.3 are answered...

CIS-336: Lab 3: Building the Physical Model LAB OVERVIEW Scenario and Summary The lab for this week addresses taking a logical database design (data model) and transforming it into a physical model...

A computer science department staff employee has a unique account name, first name, last name, titles, and phone extensions. First and last names are non - null. Computer science department staff can...

Scenario and Summary The lab for this week addresses taking a logical database design (data model) and transforming it into a physical model (tables, constraints, and relationships). As part of the...

* * Please Solve All, Post Scripts, and Screenshots * * The assignment is to create a SQL script in Oracle SQL Developer Data Modeler and run it into Oracle APEX. Here are the steps and deliverables....

For this set of Review Questions, we will create and use a database for the Wedgewood Pacific Corporation (WPC) that is similar to the Microsoft Access database we created and used in Chapters 1 and...

Mariel wanted to avail of a cellphone plan that offers a monthly fee of P=2,500.00. It includes 240 minutes of call and charges 7.50 for each additional minute of usage. How much is her monthly cost...

Dexcon Technologies, Inc., is evaluating two alternatives to produce its new plastic filament with tribological (i.e., low friction) properties for creating custom bearings for 3-D printers. The...

Weller Company's budgeted unit sales for neat year are provided below: \ table [ [ , tot Beartar, 3 nd cuarter,Ind Quarter, 4 th Quertar ] , [ Poigeted unit sales, 2 7 4 , 6 0 0 , 2 8 , 6 0 0 , , , a...

Members of the board at ACE Corporation received three proposals for a machine they may want to purchase. They also can choose to invest their capital and receive an interest rate of 15% annually....

Mr. "X", a friend of yours, is asked to invest in the following project: Installation and operation of a facility with a life span of five years. The initial investment is $90M. It will have a net...

Equipment is bought for an initial cost of $20,000. Its operation will result in a net income of $6,000/Yr for the first year, increasing by $1,000 each year after year 1. At the end of the fifth...

Production equipment is bought at an initial price of $10,000. The annual operation and maintenance cost is $100. The salvage value at the end of the 15-year life is $500. Using MARR of 10%,...

Board members at Darbol Corporation received two proposals for a machine they may want to purchase. They also can choose to invest their capital and receive an interest rate of 15% annually. Using...

With respect to E procurement which of the two types of EOB are websites organized around a supplier and use a hubs B functional hubs and organizational hubs see vertical and horizontal hubs the...

In the section on PVFs WebStore, it is mentioned that Jim Woo will prepare a list of ISP Web-hosting services. Prepare such a list for website maintenance. Contrast the responsibilities of the ISP...

Describe what is meant by ISP and the steps involved in the process.

In what ways could you identify that one IS project is riskier than another?

As part of a study of corporate employees, the director of human resources for PNC Inc. wants to compare the distance traveled to work by employees at its office in downtown Cincinnati with the...

The publisher of Celebrity Living claims that the mean sales for personality magazines that feature people such as Angelina Jolie or Paris Hilton are 1.5 million copies per week. A sample of 10...

Many grocery stores and large retailers such as Walmart and Kmart have installed self-checkout systems so shoppers can scan their own items and cash out themselves. How do customers like this service...