Question: 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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!