Question: Question ( 3 ) ( a ) Consider the relational database of Employee. Give an expression in the relational algebra to express each of the

Question (3)(a) Consider the relational database of "Employee". Give an expression in the relational algebra to express each of the following queries: (1) Find the names of all employees who live in city "Miami.(0) 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) 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) Oyear 22009(takes) student (ii) Oyear 2009(takes a student)(iii) Ilid, name, course.jd (students 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 Programming Questions!