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

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

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!