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.

Figure 5.5

Transcribed Image Text:

EMPLOYEE Fname Minit Lname Ssn Sex Salary Super_ssn Dno Bdate Address DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation Dnum WORKS ON Pno Essn Hours Figure 5.5 Schema diagram for the COMPANY relational database schema. DEPENDENT Essn Dependent_name Relationship Sex Bdate