Reference no: EM133702912

Consider a database schema with three relations:
Actors (aid:integer, aname:string, age:real, city:string, state:string)
Playsin(aid:integer, mid:integer, character:string)
Movies(mid:integer, mname:string, year:integer, studio:string)
Primary keys are underlined in each relation. Attribute aid uniquely identifies an actor in Actors
relation. An actor has a an id (aid), a name (attr. aname), an age (attr. age), and a city and
state(attributes city and state). Attribute mid uniquely identifies a movie in relation Movies. A
movie has an id(mid), a name(attr. mname), a year (attr. year) and a studio that produced it
(attr. studio). Relation Playsin contains information about actors who played in movies.
Attribute character = the character name of the actor with aid when playing in mid.

Write relational algebra queries for the following queries:
a) Find the information about movies produced by 'WB' or 'Universal' studios.
b) Find the names of actors who are older than 25 and are from state VT.
c) Find the names and ages of the actors who played only in movies only in 2015.
d) Find the names, age and city of actors who are from Boston MA and played some movies produced by 'Universal' studio.
e) Find the name and age of the actors who played in movies both in 2012 and 2018.
f) Find the names of the actors older than 30 who played in a movie produced by 'WB' studio in 2018.
g) Find the information about actors and movies they played in. The result should contain the name and age of actors and the name of movies.
h) Find the names and ages of actors from MA who played as character 'Batman'.
i) [CS630 only] Find the name and age of actors who played in movies produced by 'Paramount' (in any year) and never played in any movie produced by 'WB' in year 2020.
j) [CS630 only] Find names of movies in which actors from both MA and NY states played.