Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello, these are the instructions for the image above: -Write the SQL to CREATE the tables. Be sure to include appropriate entity, domain, operational, and


sqlguidelines.png 

Hello, these are the instructions for the image above:

-Write the SQL to CREATE the tables. Be sure to include appropriate entity, domain, operational, and referential integrity constraints.

-Write the SQL to populate (INSERT data into) the tables.

Create and populate the database tables: 1. Write the SQL to CREATE the tables. Be sure to include appropriate entity, domain, operational, and referential integrity constraints. 2. Write the SQL to populate (i.e., INSERT data into) the tables. Write the SQL queries (i.e., SELECT statements) to answer the following questions: 3. What is the duration of the flight(s) with trip ID 1971? 4. Provide all data recorded for flights that lasted 45 minutes or less. 5. What is the longest duration for any flight? 6. Which flights were operated by Airline ID 102? 7. Create a list of travelers who are younger than 18 years old. 8. What is the average duration of all flights? 9. Provide the airport city name and monthly number of passengers of airport having a yearly number of passengers exceeding 55 million but less than 85 million. 10. What is the difference in time (minutes) between the longest and the shortest flight in terms of duration? 11. Give the last name and age of travelers who are not diamond status. 12. Provide the trip ID, airport ID, and duration of all flights that will occur over the next 180 days. 13. How many trips are listed in the database? 14. How many flights were operated by airline ID 107? 15. What is the total duration of all flights to airport ID 105? 16. What is the average duration of all flights to Chicago?

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

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

Students also viewed these Databases questions

Question

What is context-sensitive help?

Answered: 1 week ago