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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!