Exercise 6

Please write the Relational Algebra operation and Relational Calculus for the following questions

a) SELECT Name FROM User WHERE Age more than 25; 

b) SELECT all information FROM User WHERE id greater than 2 OR Age not equal to 31

c) SELECT Name , Age and Occupation name of all users

d) SELECT all information about users, their occupation name and the City name where they live

e) SELECT the name and gender of users where the city they live is Boston

f)  SELECT the average age of the Users based on Occupation