Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Query Formulation And Administration Using Oracle And PostgreSQL

Authors: Michael Mannino

8th Edition

1948426951, 978-1948426954

Students also viewed these Databases questions

Question

understand the role of competencies and a competency framework

Answered: 1 week ago