Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

movie_cast act id mov_id role actor Integer Integer char (30) act id act fname act Iname act gender integer char (20) char (20) char (1)

image text in transcribed
image text in transcribed
movie_cast act id mov_id role actor Integer Integer char (30) act id act fname act Iname act gender integer char (20) char (20) char (1) genres gen_id gen title Integer char (20) movie director dir d dir fname Integer char (20) char (20) movid integer mov te char (50) mov year integer mov time integer mov lang char (50) mov direl date movrel country char (5) movie genres mov id gen id dir name reviewer movie_direction dir id mov id Integer integer Integer Integer Movid revid rev stars num orating integer y revid rey name integer char (30) integer 3. Consider the following database schema: Movie (movieID, title, length, year) Studio (movieID, studioName) a. Write down the query to find the titles and years of movies made by "FOX" that are at least 100 minutes long. b. Show the initial query tree

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Databases questions