Employee Id Empname Age Occupationid Cityid Occupation Occupationid Occupname City Cityid Q24418251

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

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"