Untitled

3. (12) Write relational algebra queries to answer the following questions for Ullman and Widom’s movie database example. Note that these are the same queries used in Question 5.

 

a. List all the information in the Movie table.

b. What year was Star Wars released?

c. Who were the male stars in Titanic?

d. Which movies (if any) are longer than Gone With the Wind? List movies and length.

e. How many movies of each genre are there? List genres and number in each.

f. What movies were made by Disney after 1990?

 

Ullman and Widom’s Movie Database Schema

 

Movies (title, year, length, genre, studioName, producerC#)

StarsIn (movieTitle, movieYear, starName)

MovieStar (name, address, gender, birthdate)

MovieExec (name, address, cert#, netWorth)

Studio (name, address, presC#)