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.
-
Identify and explain some of the reasons why defined benefit pension plans create accounting challenges for companies that offer them.
-
Suppose the (vector) Markov process Xt, has the following dynamics, where the error term is jointly normal and serially uncorrelated. Suppose rt is a short rate, while Rt is a long rate. (a) Derive a...
-
For each of the following situations, calculate the \(t\)-statistic \((t)\) : a. \(\mathrm{X}^{-}=12.00 ; \mu=10 ; s \mathrm{X}^{-}=2.00\) b. \(X^{-}=6.00 ; \mu=9 ; s X^{-}=1.50\) c. \(X^{-}=4.25 ;...
-
Arthur Andersen LLP was the auditor for Enron, WorldCom, Waste Management and other companies that committed fraud. Andersen was forced to shut its doors forever after a U.S. Department of Justice...
-
1. As a Marketing researcher, you would like to establish the-cause-and-the-effect relationship between two variables X and Y (e.g., X causes Y). Explain why such a causal relationship is very hard...
-
Professor Balkaran wants to sell his Bugatti Car and advertises it in the local FIU newspaper at $1,370,000, giving his telephone number, one of his students at FIU sees the advertisement and rings...
-
Which of the following is the best definition of forward contract? Multiple Choice Long-term financial risk arising from permanent changes in prices or other economic fundamentals. A forward contract...
-
How do design patterns, such as the Singleton pattern or the Observer pattern, aid in the development of scalable and maintainable software architectures?
-
Are Pets Family or Property? Historically, pets were considered property. Recently, many states, including New York, are revisiting the question regarding the definition of pets as property. Make a...
-
what ways can higher-order functions be leveraged to enhance code modularity and facilitate functional programming paradigms?
-
CHILD, FAMILY AND COMMUNITY SERVICE ACT[RSBC 1996] CHAPTER 46 Make a summary of this chapter? https://www.provincialcourt.bc.ca/types-of-cases/family-matters
-
Topic 1: Why the Civil Rights Act of 1964 was needed and why is it outdate now or why it is not outdated? Topic 2: Men now receive family and medical leave; explain the law and exactly what it means?...
-
You are working for an audit firm and your job is to work on a team conducting audits for multiple clients. As part of the audit process, you are required to keep copies of the clients source...
-
Explain why each of the following is either a private good or a public good: traffic lights, in line skates, a city park, a chicken salad sandwich, a tennis racket, national defense, a coastal...
-
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)?
-
Calculate (in terms of a single ket state and no operators) exp{ila a+ B(a+a)]}|a). (8.108)
-
Can one have a picture in which operators don't evolve in time other than the Schrdinger picture?
-
Use the Sommerfeld method for a particle in one dimension with a quartic potential, instead of a quadratic one, \(V(x)=\lambda x^{4}\). What is the resulting reduced equation, and can you describe...
Study smarter with the SolutionInn App