Answered step by step
Verified Expert Solution
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
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
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