Question: Question (3) (Total: 15+10-25 points) (a) (15 points) Consider the relational database of Employee. Give an expression in the relational algebra to express each of
Question (3) (Total: 15+10-25 points) (a) (15 points) Consider the relational database of "Employee". Give an expression in the relational algebra to express each of the following queries: i. Find the names of all employees who live in city "Miami". li. Find the names of all employees whose salary is greater than $100,000. ii. Find the names of all employees who live in "Miami" and whose salary is greater than $100,000. (b) (3+3+4 = 10 points) Consider the following expressions, which use the result of a relational algebra operation as the input to another operation. For each expression, explain in words what the expression does. Assume there are two schemas or relations i.e. student and takes (means student takes courses). i. year2 2009 (takes)D, student ii. yearz 2009 (takes student) li. IlID, name, course jd (student o takes)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
