Consider the following Movie database for Question 1-2: actor act_id act_fname act_Iname act_gender director dir_id dir_fname...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the following Movie database for Question 1-2: actor act_id act_fname act_Iname act_gender director dir_id dir_fname dir_Iname movie_direction dir_id mov_id integer char (20) char (20) char (1) integer char (20) char (20) integer integer 18 18 movie_cast act_id mov_id role movie integer integer char (30) mov_id mov_title mov_year integer char (50) integer integer char (50) mov time mov_lang mov_ dt_rel date mov_rel_country char (5) reviewer rev_id integer rev_name char (30) genres gen_id gen_title movie genres mov_id gen_id rating mov_id rev_id rev_stars integer char (20) integer integer integer num_o_ratings integer integer integer 1. Write the SQL queries for the following items, considering the SQL Optimization Techniques studied in classes. a. Retrieve the name and year of the movies. b. Retrieve title and language of all the English movies which were released before 1998. c. Retrieve a list of first and last names of all the actors who were cast in the movie "Titanic" and the roles they played in that production. 2. Write the SQL queries for the following items, considering the SQL Optimization Techniques studied in classes. c. Consider the following query specified on Movie database: SELECT A.act_Iname FROM actor A, movie_cast C, movie M WHERE M.mov_title = 'Titanic' AND M.mov_id = C.mov_id AND A.act_id = C.act_id AND A.act_gender = 'M' a. List all the actors who have not acted in any movie between 1990 and 2000. b. Find how many movies are there in each genre. 18 Consider the following Movie database for Question 1-2: actor act_id act_fname act_Iname act_gender director dir_id dir_fname dir_Iname movie_direction dir_id mov_id integer char (20) char (20) char (1) integer char (20) char (20) integer integer 18 18 movie_cast act_id mov_id role movie integer integer char (30) mov_id mov_title mov_year integer char (50) integer integer char (50) mov time mov_lang mov_ dt_rel date mov_rel_country char (5) reviewer rev_id integer rev_name char (30) genres gen_id gen_title movie genres mov_id gen_id rating mov_id rev_id rev_stars integer char (20) integer integer integer num_o_ratings integer integer integer 1. Write the SQL queries for the following items, considering the SQL Optimization Techniques studied in classes. a. Retrieve the name and year of the movies. b. Retrieve title and language of all the English movies which were released before 1998. c. Retrieve a list of first and last names of all the actors who were cast in the movie "Titanic" and the roles they played in that production. 2. Write the SQL queries for the following items, considering the SQL Optimization Techniques studied in classes. c. Consider the following query specified on Movie database: SELECT A.act_Iname FROM actor A, movie_cast C, movie M WHERE M.mov_title = 'Titanic' AND M.mov_id = C.mov_id AND A.act_id = C.act_id AND A.act_gender = 'M' a. List all the actors who have not acted in any movie between 1990 and 2000. b. Find how many movies are there in each genre. 18
Expert Answer:
Answer rating: 100% (QA)
a Required query select movtitle as MovieTitle movyear as ReleaseYear from movie sample outp... View the full answer
Related Book For
Fundamentals Of Database Systems
ISBN: 9780133970777
7th Edition
Authors: Ramez Elmasri, Shamkant Navathe
Posted Date:
Students also viewed these databases questions
-
Explore Recent Trends in Database Administration. (cite and reference sources)
-
1-Write the SQL queries for the following items, considering the SQL Query Optimization Techniques studied in classes. (a)List all the actors who have not acted in any movie between 2015 and 2020....
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Discuss three quotes from the YouTube video (put time stamps after you type the quote) and explain why chose this quote. https://youtu.be/h86MGjGAtYk?si=_1hMyOefl0L3E4ox Example: Radio is "still...
-
Diphenadione inhibits the clotting of blood; that is, it is an anticoagulant. It is used to control vampire bat populations in South America by a Trojan horse strategy. A few bats are trapped,...
-
Harrods PLC has a market value of 110 million and 5 million shares outstanding. Selfridge Department Store has a market value of 34 million and 2 million shares outstanding. Harrods is contemplating...
-
Smart Manufacturing Systems Pty Ltds accountant recently prepared the following data from the companys accounting records for the year ended 30 June 2025. Required (a) Prepare a cost of goods...
-
1. To what events must the ticket processing system respond? Create a complete event table listing the event, trigger, source, use case, response, and destination for each event. 2. Draw an...
-
Dr. Tepper (Employee), a veterinarian licensed in Texas, enters into an Employment contract with Dr. Meng. Also, a licensed veterinarian, Dr. Meng (Employer) owns and operates the Barking Pet Clinic...
-
Part of developing a long-term R&D strategy is to locate facilities in countries that are widely known to be competitive. Your company seeks to develop R&D facilities in Asia to counter recent...
-
Assume for the moment that the PE-return index is genuinely representative of PE funds' returns, on average. Analyze whether an investor would gain from adding a portfolio of PE funds to a market...
-
Consider a business that follows the EOQ policy in ordering from its supplier. (a) What would be the increase (in percentage) in EOQ if demand increases by 300% (i.e., demand quadruples)? (b) What...
-
Solve: log(6x-8) = log(2x-4).
-
A consultant recommends thatthe same beer distributor replace the Central Austin warehouse with two smaller and identical warehouses - one in north Austin and the other in South Austin.The motivation...
-
What would Milton Friedman do? In Cicero's De Officiis, we learn about a merchant who has set sail to Rhodes at a time of famine. Antipater and Diogenes take different positions about how this...
-
How should organizational justice be implemented in the organization to promote work motivation?
-
04) Find the 0.2, 1 (a) q (b) .10 (c) 8 (d) 11 CS 1 geometric of terms in the sequence 390625 number of terms 5,25
-
Is it a breach of fiduciary duty for a director of a real estate investment trust (REIT) negotiating a joint venture on behalf of the REIT with another director for the development of a portfolio of...
-
Discuss the factors that do not appear in centralized systems but that affect concurrency control and recovery in distributed systems.
-
What is Apache Pig, and what is Pig Latin? Give an example of a query in Pig Latin.
-
What is the multidimensional data model? How is it used in data warehousing?
-
Assess two different quantitative measures on the temptation traditional model and temptation stable analysis patterns, and explain the differences between each of the measures.
-
What do you think are the implementation issues for the AnyUnit BO, when used in the Temptation stable analysis pattern?
-
Draw with a class diagram and describe the applicability of the temptation SAP in a scenario, where the YouTube channel is trying to tempt people to come and watch the uploaded videos, subscribe to...
Study smarter with the SolutionInn App