Question: I need the mysql querry for this problem, that I cannot seem to get right. Below is the database structure. List the airport code of

I need the mysql querry for this problem, that I cannot seem to get right. Below is the database structure.

List the airport code of origin and airport code of destination, the departure and arrival time, the airline name, and plane manufacturer and model for all flights that will occur in the future. (The manufacturer and model may be in two separate fields; they do not need to be concatenated.)

Airlines Database

Primary Key = Plane_ID

Foreign Key = Carrier_ID references Carriers (Carrier_ID)

Aircraft

Plane_ID

Manufacurer

Model_Num

Original_Purchase_Date

Last_Service

Carrier_ID

Number_of_Seats

Airports

Airport_Code

Airport_Location

Year_Opened

Nuber_of_Terminals

Primary Key = Airport_code

Carriers

Carrier_ID

Carrier_Name

Primary Key = Carrier_ID

Flights

Flight_ID

Plane_ID

Carrier_ID

Airport_Code_Origin

Airport_Code_Destination

Departure_DateTime

Arrival_DateTime

Primary Key = Flight_ID

Foreign Key = Airport_Code_Origin references Airports(Airpot_Code)

Airport_Code_Destination references Airports(Airport_Code)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
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!

Q:

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Q:

This policy will be reviewed no later than 5 years of its authorisation date. At this point it will need to be re-authorised by the relevant authority at Xxz Financial Services Version Published...

Q:

Answer the following questions in detail after reviewing the video transcripts of "THE CRASH OF FLIGHT 111 NOVA DOCUMENTARY History Life Discovery" provided at the end. Which...

Q:

Averell Cabinetry Case Overview This case is presented as close as possible to the way you may encounter it in working life. Your role is that of a newly hired HR manager. You will learn about the...

Q:

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

Q:

There are a few of the flight_info.csv pages Here's the main.py import airline, airport, flight airline_dict = {} airport_dict = {} date_dict = {} #Process CSV File #Queries def query1(): #Process...

Q:

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

Q:

Problem 5.1 Consider the AlRLINE relational database schema described below. Schema 1. AIRPORT (Airport_Code. City, State, Name) 2. AIRPLANE_TYPE(Airplane type name, Company, Max_Seats) 3....

Q:

CSE 341 Assignment 7 Question 3, Winter 2023 Please answer question 3 in CODE. The starter code is provided below. Set-up: You will complete and extend two implementations of an interpreter for a...

Q:

Business Event Analysis: Complete the following table based on the specified NBD event. Receive Shipment (From Supplier) Trigger(s) (also indicate type) Collected Data (originates as input for event)...

Q:

20. In the following compounds, (IV) ?? 27 H H H the order of basicity is (a) IV>I> III > II (b) III>I>IV> II (c) II>I>III > IV (III) (d) I>III>II> IV

Q:

Describe the basis of goal setting theory and name and describe the characteristics of SMART goals and SMART2 goals. Which of the two set of goals are more applicable in today's organizations?

Q:

An investor's ability and willingness to accept risk is termed: Question 2 5 options: Risk tolerance level. Risk aversion. Risk - free rate of return. Risk seeking.

Q:

Decision on whether to launch a new product A company is currently manufacturing at only 60% of full practical capacity, in each of its two production departments, due to a reduction in market share....

Q:

1. Develop a questionnaire to measure the degree to which the work environment supports transfer of training. Include the questions and the rating scales you would use. Use the checklist in Table 5.5...

Q:

5. Choose the appropriate evaluation design based on the characteristics of the company and the importance and purpose of the training.

Q:

8. One way to diagnose transfer of training problems or to ensure that transfer of training occurs is to complete the matrix shown below. This matrix considers the responsibilities of the manager,...