Question: 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

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!

Ivanhoe Company is considering the purchase of a new machine. The invoice price of the machine is $151,000, freight charges are estimated to be $3,700, and installation costs are expected to be...

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...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Discuss why the length of an OH bond obtained from X-ray diffraction experiments averages 85 pm whereas that obtained in neutron diffraction experiments averages 96 pm. Would you expect to see...

a. What is the 2-year forward price for a 1-year bond? b. What is the price of a call option that expires in 2 years, giving you the right to pay $0.90 to buy a bond expiring in 1 year? c. What is...

Depreciation expense, amortization of patents, and amortization of bond discount are examples of items that are added to net income when using the indirect method of presenting cash flows from...

=+24. Safety switch. An industrial machine requires an emergency shutoff switch that must be designed so that it can be easily operated with either hand. Design an experiment to find out whether...

Given below is a list of account balances for Currie Hospital as of December 31, 2004. Prepare a balance sheet as of December 31, 2004, in good form. AccountBalance Gross plant & equipment...

The Open Web Application Security Project ( OWASP ) provides a distillation of several of the most well known sets of principles except _ _ _ _ _ _ _ _ _ _ _ _ _ _ . a . apply defense in depth for...

Question 1 Below are the opening and closing balances of Sweet Dreams Enterprise, a trader at the night market for year 2014 and 2015: As at 31.12.2014 Van - GH18,000 Furniture - GH5,400 Trade...

An aluminium rod is a total of 900mm long and 50mm in diameter. Part of this bar is turned down to 40mm diameter for a length of 50mm each end. Calculate the total elongation when subjected to an...

Mr. Manalo opened a mini grocery store with Business name Manalo Trading. Operations began on April 1, 2021, and the following transactions were completed during the month: 1 Mr. Manalo withdrew...

Sharon contributes 5% of her annual earnings of $40,000.00 to her defined contribution pension plan. Her employer matches her contributions. Calculate Sharon's pension adjustment

Complete business activity and instalment activity statements in Australia Swanston Enterprises report GST quarterly on a cash basis. They had the following account balances (on a cash basis) for the...

14. A cylinder whose radius is 2 inches is removed from the right prism as shown. The ends of the prism have the shape of an equilateral triangle whose sides are 8 inches long. Find the volume of the...

Imprudential, Inc., has an unfunded pension liability of $568 million that must be paid in 15 years. To assess the value of the firms stock, financial analysts want to discount this liability back to...

Subprime loans have higher loss rates than many other types of loans. Explain why lenders offer subprime loans. Describe the characteristics of the typical borrower in a subprime consumer loan.

What are triggers? What purpose do they serve? How do you gain the functionality of a trigger using Access 2013?

What is context-sensitive help?

The following exercises are based on the Solmaris Condominium Group database shown in Figures 1-21 through 1-25. No computer work is required. 1. Using the types of entities found in the Solmaris...

24 Controlling the water hyacinth. Entomologists are continually searching for new biological agents to control the water hyacinth, one of the worlds worst aquatic weeds. An insect that naturally...

16 Consider the following probability distribution: a. List the values that x may assume. b. What value of x is most probable? c. What is the probability that x is greater than 0? d. What is the...