Consider the following relations for an online Cinema Booking system. The primary keys are underlined. All...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the following relations for an online Cinema Booking system. The primary keys are underlined. All attributes are of type string if not indicated otherwise. • Theaters(1ID, name, location) • Auditoriums(tlD, alD, movie title, price: integer, number of seats: integer) • Book(tID, alD, cID, seat number, date) • Customers(cID, name, address) A theater usually has several auditoriums. Assume that only the movies that are currently played on auditoriums of theaters are stored. 1. Find the names of customers who have watched movies at every theater in Gainesville. 2. Find the names of customers who never booked. 3. Find the names of customers who booked the movie titled 'Parasite' more than once. 4. Find the name of the theater that has the biggest (in terms of the number of seats) auditorium. 5. Find the names of customers who booked 'Parasite' and "End game'. 6. Find the names of movies that are playing at the theaters where the movie 'End game' is on (exclude 'End game' in your answer). Consider the following relations for an online Cinema Booking system. The primary keys are underlined. All attributes are of type string if not indicated otherwise. • Theaters(1ID, name, location) • Auditoriums(tlD, alD, movie title, price: integer, number of seats: integer) • Book(tID, alD, cID, seat number, date) • Customers(cID, name, address) A theater usually has several auditoriums. Assume that only the movies that are currently played on auditoriums of theaters are stored. 1. Find the names of customers who have watched movies at every theater in Gainesville. 2. Find the names of customers who never booked. 3. Find the names of customers who booked the movie titled 'Parasite' more than once. 4. Find the name of the theater that has the biggest (in terms of the number of seats) auditorium. 5. Find the names of customers who booked 'Parasite' and "End game'. 6. Find the names of movies that are playing at the theaters where the movie 'End game' is on (exclude 'End game' in your answer).
Expert Answer:
Answer rating: 100% (QA)
1 SELECT name FROM Theaters WHERE locationGainesville 2 SELECT name FROM Custom... View the full answer
Related Book For
Fundamentals of Database Systems
ISBN: 978-0136086208
6th edition
Authors: Ramez Elmasri, Shamkant Navathe
Posted Date:
Students also viewed these programming questions
-
Consider the following relations for an order-processing application database at ABC, Inc. ORDER (O#, Odate, Cust#, Total_amount) ORDER-ITEM (O#, I#, Qty_ordered, Total_price, Discount%) Assume that...
-
Consider the following relations for a database that keeps track of business trips of salespersons in a sales office: SALESPERSON (SSN, Name, Start_Year, Dept_No) TRIP (SSN, From_City, To_City,...
-
Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course: STUDENT (SSN, Name, Major, Bdate) COURSE (Course#, Quarter,...
-
In Exercises use the Limit Comparison Test to determine the convergence or divergence of the series. 0 1 2 n=11n+1
-
Ortega Company issued five-year, 5% bonds with a face value of $50,000 on January 1, 2016. Interest is paid annually on December 31. The market rate of interest on this date is 8%, and Ortega Company...
-
On the basis of the Pauli exclusion principle, the structure of the periodic table of the elements shows that there must be a fourth quantum number in addition to n, l, and m l . Explain.
-
Refer to the information in QS 13-4. Use that information for Tide Corporation to determine the 2016 and 2017 common-size percents for cost of goods sold using net sales as the base. Data From QS...
-
Video Superstore has hired you to design two online data entry screens. Based on what you know about the operation of a video rental store, complete the following assignments. 1. Design a weekly...
-
A 15 kg box is given a shove to the right on a horizontal, rough surface. After the hand loses contact, the box's acceleration (using standard directions) is a = (-1.2 m/s, 0). (a) What are the...
-
a. Do you agree with the controllers recommendation? Why or why not? b. Formulate an LP model for this problem. c. Create a spreadsheet model for this problem and solve it using Solver. d. What is...
-
How do the personal biases of senior leaders in the hospitality industry influence decision-making processes, organizational culture, and overall effectiveness of leadership that foster a positive...
-
Provide a short summary of the career path Discuss: What did you find of interest in the session? How does the career path fit with your own career interests?
-
Imperial Black considered both the diaspora strategy and the natural resources strategy but didn't want to proceed further with either of these strategies owing to certain constraints. It instead...
-
Explain what is meant by the empowerment of employees, how it differs from delegation of authority, and in what ways the empowerment of employees can aid the cause of good strategy execution.
-
Employee morale is an essential component of a high-performing organization. Employees who are not happy with the work environment become, at best, distracted and, at worst, destructive to...
-
Explain whether the company tends to encounter a Cycle of Failure, Cycle of Mediocrity, or Cycle of Success. Explain in detail your analysis. How is the implementation of Employee Empowerment in that...
-
. Q3. Find V (VF) and V x (V x F) if F(x, y, z) = eyz xi + cos(xy- 3z) j + xyz k.
-
The words without recourse on an indorsement means the indorser is: a. not liable for any problems associated with the instrument. b. not liable if the instrument is dishonored. c. liable personally...
-
Consider the EMPLOYEE table's constraint EMPSUPERFK as specified in Figure 4.2 is changed to read as follows: CONSTRAINT EMPSUPERFK FOREIGN KEY (SUPERSSN) REFERNCES EMPLOYEE(SSN) ON DELETE CASCADE ON...
-
Rewrite the domain relational calculus queries that followed Q0 in Section 6.7 in the style of the abbreviated notation of Q0A, where the objective is to minimize the number of domain variables by...
-
Consider the COMPANY database described in Figure 3.6. Using the syntax of Oracle triggers, write active rules to do the following: (a) Whenever an employee's project assignments are changed, check...
-
Look back at Table 15.1. Show that y4 will exceed y3 if and only if the forward interest rate for period 4 is greater than 7%, which is the yield to maturity on the 3-year bond, y3. Table 15.1...
-
Suppose the interest rate decreases to 9% as an annual percentage rate. What will happen to the prices and durations of the two bonds in Spreadsheet 16.1? A B C D E F G 1 Time until PV of CF 2...
-
a. In Concept Check 16.1, you calculated the price and duration of a 2-year maturity, 8% coupon bond making semiannual coupon payments when the market interest rate is 9%. Now suppose the interest...
Study smarter with the SolutionInn App