Question

This is Relational Algebra NOT SQL!!! I need the following 3 queries written in relational algebra.

1. Retrieve the title of all the Movies in Japanese that don't have any comment. (The language_id for Japanese is 3)

2. Find all the movie titles where an actor called “TOM” OR an actor called “BEN" acted, AND there was another actor called “MARY” acting too.

3. Find the actors that have movies in all the categories. (category IDs are numbered 1-16)

• actor
  • actor_id number
  • first_name string
  • last_name string
  • last_update string
• category
  • category_id number
  • name string
  • last_update string
• language
  • language_id number
  • name string
  • last_update string
• film
  • film_id number
  • title string
  • description string
  • release_year number
  • language_id number
  • length number
  • rating string
  • last_update string
• film_actor
  • actor_id number
  • film_id number
  • last_update string
• film_category
  • film_id number
  • category_id number
  • last_update string
• comment
  • review_id number
  • film_id number
  • reviewer_name string
  • comment string
  • score number
  • last_update string

Answer 1

if you still have any Problem regarding this question please comment and if you like my code please appreciate me by thumbs up thank you.........