Answered step by step
Verified Expert Solution
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)
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
Get Instant Access with AI-Powered 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