Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Specify the following queries on the given database schema using relational algebra. a ) Retrieve the SSNs and names ( Lname , Fname ) of
Specify the following queries on the given database schema using relational algebra.
a Retrieve the SSNs and names Lname Fname of all employees in department who work more than hours per week on both 'ProductX' and 'ProductY' projects.
b List the SSNs and names of employees who have no dependents.
c Find the SSNs and names of employees who are directly supervised by a supervisor who is directly supervised by 'James Borg'.
d Retrieve the SSNs and names of employees who work on at least one project.
e Retrieve the SSNs and names of employees who work on every project located in Stafford.
f Retrieve the name of the department with Dnumber and the lowest salary of the male employees who work in that department.
g Retrieve the highest salary of all employees the SSNs and names Lname Fname who work in the department with Dnumber
h Find the SSNs names Lname Fname and addresses of employees who work on at least one project located in Houston and whose department has a location in Houston.
i List the SSNs and last names of department managers who have the spouse as the dependent.
Step 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