Passenger table (passengerid, address etc.) Flight table (flight id, departure, destination, depDate) Booking table (cID, fid,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Passenger table (passengerid, address etc.) Flight table (flight id, departure, destination, depDate) Booking table (cID, fid, date, cost) a. Find Passengers who live in Chicago b. Total number of bookings by month of the flights departing at Chicago c. Which flight earns the most? d. What is the difference between number of flights booked to Chicago in 2022 and number of flights booked to Chicago in 2023? e. Find the names of customers who made more than two bookings before (some date). Q2. Table R with two columns and 5 rows. Contains integers. Table S with two columns and 5 rows. Contains integers. Six different possible result sets are given. a. For R.value= svalue inner join, find which of the result sets is the correct match for this query b. For full outer join, find the correct result set c. For left outer join, find the correct result set d. For right outer join, find the correct result set e. For rid > s.id, find the correct result set for a left outer join. Q4.Employee Table - has two columns - name, manager name a. Find all the managers of 'Jack' b. Find all the common managers of 'Jack' and 'aslan' Passenger table (passengerid, address etc.) Flight table (flight id, departure, destination, depDate) Booking table (cID, fid, date, cost) a. Find Passengers who live in Chicago b. Total number of bookings by month of the flights departing at Chicago c. Which flight earns the most? d. What is the difference between number of flights booked to Chicago in 2022 and number of flights booked to Chicago in 2023? e. Find the names of customers who made more than two bookings before (some date). Q2. Table R with two columns and 5 rows. Contains integers. Table S with two columns and 5 rows. Contains integers. Six different possible result sets are given. a. For R.value= svalue inner join, find which of the result sets is the correct match for this query b. For full outer join, find the correct result set c. For left outer join, find the correct result set d. For right outer join, find the correct result set e. For rid > s.id, find the correct result set for a left outer join. Q4.Employee Table - has two columns - name, manager name a. Find all the managers of 'Jack' b. Find all the common managers of 'Jack' and 'aslan'
Expert Answer:
Answer rating: 100% (QA)
Lets address each of the questions and queries Q1 Passenger Flight and Booking Tables a To find passengers who live in Chicago sql SELECT FROM Passenger WHERE address LIKE Chicago This query selects a... View the full answer
Related Book For
Operations Management Processes And Supply Chains
ISBN: 9781292409863
13th Global Edition
Authors: Lee Krajewski, Naresh Malhotra, Larry Ritzman
Posted Date:
Students also viewed these databases questions
-
Blackhawks Incorporated had the following balances at the beginning of November Credits BLACKHAWKS INCORPORATED Trial Balance November 1 AccountsDebits Cash $ 3 , 1 0 0 Accounts Receivable 5 9 0...
-
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...
-
Two positive charges, each with charge q = 2.5 nC, are placed as shown in the diagram. The distance d 0.42 m. Find the net electric potential at the point x = 0, y = 0.12 m.
-
A surfer floating beyond the breakers notes 17 waves per minute passing her position. If the wavelength of these waves is 38 m, what is their speed?
-
What qualitative factors should analysts consider when evaluating a companys likely future financial performance?
-
As with the balance sheet, compare the current-year reported figures in the profit and loss account with the information shown for the prior year. Calculate the percentage change from one year to the...
-
Mariah Enterprises makes a variety of consumer electronic products. Its camera manufacturing plant is considering choosing between two different processes, named Alpha and Beta, which can be used to...
-
Consider a 1-year zero-coupon bond with $1,000 face value. Assume today's 6-month forward rate is 6% and in six months the new 6-month forward rate can be either 5% or 7%. Also, assume th...
-
Cost Estimation at Global Green Books Publishing Global Green Books Publishing is continuing to produce customized eBooks as a key new product line for it as a successful printing and publishing...
-
How would you ensure similar problems could be avoided and service provisions improved in the future? What would this require and how should this be managed within the team in your service area?
-
Snackums, Incorporated, purchases wheat for use in its food manufacturing process. Snackums operates in a highly competitive industry and is rarely able to increase its sales price. On January 1 , 2...
-
R N- N= O----H-N N-H-----N N-H----O H Guanine H -N R R Cytosine N N= H Adenine N-HO N-----H-N -N OR Thymine 11. What type of bond allows for base pairing (represented by the dashed lines)? Compare...
-
What is the NAND only equivalent of the following circuit? D
-
What is the common difference, the general term equation, and the 12th term of the arithmetic sequence? E --5 +-6 +-7 +9 --10 +11 +12 +-13 -14 Hint: a = a + d(n-1), where a is the first term and d is...
-
In 2024, Space Technology Company modified its model Z2 satellite to incorporate a new communication device. The company made the following expenditures: Basic research to develop the technology...
-
You have one coupon bond from a Mediterranean country with a nominal value of 1 million euros. Coupon interest of 5% is paid on this bond once a year. There are 8 years left until the bond is...
-
Find the intercepts and then graph the line. (a) 2x - 3y = 6 (b) 10 - 5x = 2y
-
Consider this sign seen in a local restaurant: To-go orders do NOT include complimentary chips and salsa. If you have any questions, see our management, NOT our employees. What Impact does this...
-
The mayor of Cambridge, Colorado, wanting to be environmentally progressive, decides to implement a recycling plan. All residents of the city will receive a special three-part bin to separate their...
-
Horizon Cellular manufactures cell phones for exclusive use in its communication network. Management must select a circuit board supplier for a new phone soon to be introduced to the market. The...
-
Baerg & Vetzel, a public accounting firm, were the auditors of South-Western Development, Inc., a real estate company that owned several shopping centres in southwest ern Ontario. It was...
-
A partner in your public accounting firm has asked you to explain to a group of juniors the importance of engagement letters and the importance of following up unusual or unexplained items discovered...
-
Marino Rossi, a public accountant, audited the finan cial statements of Newfoundland Rugs Ltd. Cooke, the pres ident of Newfoundland Rugs, told Rossi that the company was planning a private placement...
Study smarter with the SolutionInn App