Problem

Specify and execute the following queries in relational algebra (RA) using the RA interp...

Specify and execute the following queries in relational algebra (RA) using the RA interpreter on the COMPANY database schema in Figure 5.5.

a. List the names of all employees in department 5 who work more than 10 hours per week on the ProductX project.


b. List the names of all employees who have a dependent with the same first name as themselves.


c. List the names of employees who are directly supervised by Franklin Wong.


d. List the names of employees who work on every project.


e. List the names of employees who do not work on any project.


f. List the names and addresses of employees who work on at least one project located in Houston but whose department has no location in Houston.


g. List the names of department managers who have no dependents.

Step-by-Step Solution

Request Professional Solution

Request Solution!

We need at least 10 more requests to produce the solution.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the solution will be notified once they are available.
Add your Solution
Textbook Solutions and Answers Search