Question: Write tuple relational expressions to solve problems 1-8: 1-4) Exercise 8.16, parts a, c, i, and j of Elmasri/Navathe 7 th edition [6 th Ed.
Write tuple relational expressions to solve problems 1-8:
1-4) Exercise 8.16, parts a, c, i, and j of Elmasri/Navathe 7th edition [6th Ed. - Problem 6.16]. You do not need to show the result of the query on a specific database state.
Specify the following queries on the COMPANY relational database schema shown in Figure 5.5 using the relational operators discussed in this chapter. Also show the result of each query as it would apply to the database state in Figure 5.6.
a. Retrieve the names of all employees in department 5 who work more than 10 hours per week on the ProductX project.
c. Find the names of all employees who are directly supervised by 'Franklin Wong'.
i. Find the names and addresses of all employees who work on at least one project located in Houston but whose department has no location in Houston.
j. List the last names of all department managers who have no dependents.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
