How do I solve this problem?
6.16) 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 3.6.
a. Retrieve the names of all employees in department 5 who work more than 10 hours per week on the ProductX project.
The relational operators noted refer to sigma, pi,
, U, and
Figure 5.5 wasn't in the book; Figure 6.5 looked relevant.
The related figures are: