Consider the Movies, Stars, Studios Database with the following 5 relations: Movies (title, vear, length, genre,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the Movies, Stars, Studios Database with the following 5 relations: Movies (title, vear, length, genre, studioName, producerC#) Stars (movieTitle, movieYear, starName ) MovieStar (name, address, gender, birthdate) MovieExec (name, cert#, address, networth) Stud (name, address, presC#) where movie executives can be movie producers or studio presidents, and they are identified by unique certificate numbers. Assume that names are unique, there is one producer of each movie and there is one president of each studio. (Please ask for clarifications if you have questions about the relations and/or the semantics of the following queries!). Express the queries below using SQL. 1. Find names of the producers of "Emma Stone" movies (1.e. movies having Emma Stone as a star) without using subqueries. 2. Find pairs of names consisting of a movie star and a movie executive sharing the same address. 3. Find names of movie stars who starred in no movies produced by "Sony" studios in 2019 (with using "EXCEPT" operator). 4. Find names of movie stars who starred in no movies produced by "Sony" studios in 2019 (without using "EXCEPT" operator). 5. Find the titles of movies that have been used for two or more movies. 6. Find the number of movies made by "Sony" studios that "Rami Malek" stars in. 7. Find the studio names of movies "Emma Stone" stars in, and output for each such studio, the studio name and the number of "Emma Stone" movies produced by that studio. S. Find names of movie stars who star in only movies made by "Sony". 9. Find the Studio names, and names of studio presidents of studios which have "Emma Stone" starring in every movie the studio produce. 10. Find names of producers of "Emma Stone" movies (ie. movies having Emma Stone as a star), using a subquery in FROM. Consider the Movies, Stars, Studios Database with the following 5 relations: Movies (title, vear, length, genre, studioName, producerC#) Stars (movieTitle, movieYear, starName ) MovieStar (name, address, gender, birthdate) MovieExec (name, cert#, address, networth) Stud (name, address, presC#) where movie executives can be movie producers or studio presidents, and they are identified by unique certificate numbers. Assume that names are unique, there is one producer of each movie and there is one president of each studio. (Please ask for clarifications if you have questions about the relations and/or the semantics of the following queries!). Express the queries below using SQL. 1. Find names of the producers of "Emma Stone" movies (1.e. movies having Emma Stone as a star) without using subqueries. 2. Find pairs of names consisting of a movie star and a movie executive sharing the same address. 3. Find names of movie stars who starred in no movies produced by "Sony" studios in 2019 (with using "EXCEPT" operator). 4. Find names of movie stars who starred in no movies produced by "Sony" studios in 2019 (without using "EXCEPT" operator). 5. Find the titles of movies that have been used for two or more movies. 6. Find the number of movies made by "Sony" studios that "Rami Malek" stars in. 7. Find the studio names of movies "Emma Stone" stars in, and output for each such studio, the studio name and the number of "Emma Stone" movies produced by that studio. S. Find names of movie stars who star in only movies made by "Sony". 9. Find the Studio names, and names of studio presidents of studios which have "Emma Stone" starring in every movie the studio produce. 10. Find names of producers of "Emma Stone" movies (ie. movies having Emma Stone as a star), using a subquery in FROM.
Expert Answer:
Answer rating: 100% (QA)
1 Find names of the producers of Emma Stone movies SELECT DISTINCT mename FROM MovieExec me Movies m Starts s WHERE mproducerC mecert AND smovieTitle ... View the full answer
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these accounting questions
-
Star Studios is looking to purchase a new building for its upcoming film productions. The company finds a suitable location that has a list price of $1,600,000. The seller gives Star Studios the...
-
A video movie rental store is using a relational database to store information on movie rentals to answer customer questions. Each entry in the database contains the following items: Movie Number...
-
Movie studios are in something of a dilemma lately when it comes to planning their future channel strategy for distribution of their films. Electronic distribution is very profitable because, of the...
-
Express the quantity of 3.225 kJ in calories.
-
A building contractor is preparing a bid on a new construction project. Two other contractors will be submitting bids for the same project. Based on past bidding practices, bids from the other...
-
What are automatic reinvestment plans, and how do they differ from automatic investment plans?
-
What leadership theories might apply in this case? Angie was an exceptional catheterization laboratory technician who was respected by her teammates. When the director of the cath lab took another...
-
Your roommate asks your help on the following questions about CVP analysis formulas. (a) How can the mathematical equation for break-even sales show both sales units and sales dollars? (b) How do the...
-
The question :- Determine the remainder when 2^112 is divided by 7. Your solution must be well written and your conclusion clearly formulated. Explain reasoning using both text and mathematical...
-
On January 1, 2023, Pulaski, Incorporated, acquired a 60 percent interest in the common stock of Sheridan, Incorporated, for $392,400. Sheridan's book value on that date consisted of common stock of...
-
I want you to offer me a cross-border journalism project. You are expected to answer the following questions: 1What is your cross-border journalism idea? 2 How and on what platforms youll find...
-
Pristine Aircraft Maintenance has received four Boeing 737 airplanes that require maintenance. Airplane SW-023 will require 4 days of hull inspection and 3 days of painting, Airplane DL-040 will...
-
Gourmet Food Support (GFS) is a commercial caterer that prepares salads, soups, and baked goods, primarily for sale through other restaurant kitchens. The bakery area of GFS is equipped with one...
-
Layla Company uses the periodic inventory system. Layla started the period with \(\$ 22,000\) in inventory. The company purchased an additional \(\$ 25,000\) of merchandise and returned \(\$ 3,000\)...
-
The battery in Figure P31.95 has internal resistance \(R_{\text {batt }}=13.0 \Omega\) and maintains an emf \(\mathscr{E}=20.0 \mathrm{~V}\). What is the resistance \(R\) of the resistor connected in...
-
Norman Co. borrowed \(\$ 15,000\) from the local bank on April 1, 2011, when the company was started. The note had an 8 percent annual interest rate and a one-year term to maturity. Norman Co....
-
Limited liability company (LLC) members can be real persons or they can be other LLCS. True False
-
CRUZ, INC. Comparative Balance Sheets December 31, 2015 CRUZ, INC. Income Statement For Year Ended December 31, 2015 Required Use the indirect method to prepare the cash provided or used from...
-
Fitchwood is a relatively small company (annual premium revenues less than $1B per year) that insures slightly more than 500,000 automobiles and about 200,000 homes. For what types of purposes might...
-
Describe the components and structure of a typical SQL environment.
-
What are the benefits of enforcing the integrity constraints as part of the database design and implementation process (instead of doing it in application design)?
-
Compare and contrast the four capital budgeting methods
-
Compute payback period-unequal cash inflows (Learning Objective 2) Refer to the Allegra Data Set. Calculate the DVR project's payback period. If the DVR project had a residual value of \(\$...
-
Use discounted cash flow models to make capital investment decisions
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App