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

Question

Specify and execute the following queries in relational algebra (RA) using the RA interpreter on the COMPANY database schema in Figure 3.5. a. List the names ofall employees in department 5 who work more than 10 hours per week on the ProductX project. b. List the names ofall 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 ofemployees who work on every project. e. List the names ofemployees who do not work on any project. f. List the names and addresses ofemployees who work on at least one proj- ect located in Houston but whose department has no location in Houston. g. List the names ofdepartment managers who have no dependents.

Explanation / Answer

what is figure 3.5 ............?????

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.