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 : 200Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started