Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem Set . Given the following database that stores Hollywood movie information Movies (title, year, length, genre, studioName, ProducerName) StarsIn (movieTitle,starName, pay) MovieStar (name, address,
Problem Set . Given the following database that stores Hollywood movie information Movies (title, year, length, genre, studioName, ProducerName) StarsIn (movieTitle,starName, pay) MovieStar (name, address, gender, birthdate) MovieExecutive name, address, certificate_num, networth) where the underlined attributes are the primary keys. The following foreign keys also exist: Starsln.starName-MovieStar.name Starsln.movieTitle Movies.title Movies.ProducerName->MovieExecutive.name Write the following queries in SQL 3. Print the names of actors who starred in both an MGM (studio name) movie and a Universal (studio name) movie; 4. What is the average length of movies produced by Kevin Costner
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started