Employee (Id, emp_name, age, occupation_Id, city_Id) Occupation(occupation_id, occup_name) City (city_id, city_name)
Consider the above relational database. Give an expression in the relational algebra toexpress each of the following queries:
a. Find the names and ages of allemployees who work in “New York”.
b. Find the names and cities ofall employees who work as “Software Engineer”.
Asked Oct. 18, 2017