Question: This problem is based on Elmasris company database. For each of the following, specify the query using relational algebra (you do not have to show
This problem is based on Elmasris company database. For each of the following, specify the query using relational algebra (you do not have to show the resulting output tables, just the query): (a) Find the ssn of employees who work on Project number 40. (b) Find the name of the employee supervising Franklin Wong. (c) Find the names of employees who do not work in the Marketing department. (d) Find the names of employees who work on every project. (e) Find the names of employees who work on on ProductZ and who have a dependent. (f) Find the names of the employees and the names of the departments they work for, for every employee who has a son.
the answer should be relational algebra with projection selection join symbolsnot a query.
ick for more details. Enable Editing [EN] company database Figure 5.6 WORKS ON 30 30 0 35.0 30 : 200
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
