Using Relation Algebra

ACTOR (actor_id, first_name, last_name, last_update)

LANGUAGE (language_id, name, last_update)

CATEGORY (category_id, name, last_update)

FILM (film_id, title, description, release_year, language_id, length, rating, last_update)

FILM_ACTOR(actor_id, film_id, last_update)

FILM_CATEGORY (film_id, category_id, last_update)

COMMENTS (review_id, film_id, reviewer_name, comment, score, last_update)

To write these queries it is strongly recommended to use RelAx (view the document

in Canvas about how to use it). The query (set of queries) generated in Relax can be

copied and pasted as a solution (in fact that is what is expected).

6.Find all the movie titles where and actor called TOM OR an actor called BEN

acted, where there was another actor called MARY acting too. (That means

movies with TOM and MARY, movies with BEN and MARY and movies with

TOM, BEN and MARY)

7.Find the reviewers that have reviewed movies in all the categories.