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.  This problem is based on Elmasris company database. For each of

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

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!