HW# 3 Homework (Relational Algebra) 50 points COSC 578 Dr. Karne Specify the following queries on the company database using the relational algebra discussed in the class. Also, show results of intermediate and final steps to validate your answers. (For each problem 10 points; 5 points for individual steps; 3 points for the intermediate results; and 2 points for the final result) 1. Retrieve the names of all employees in department 5 who work more than 10 hours per week on the ‘ProductX’ project. 2. List the names of all employees who have a dependent with the same first name as themselves. 3. Find the names of all employees who are directly supervised by ‘Franklin Wong’. 4. List the names of all employees who do not work on any project. 5. List the names of all department managers who have no dependents.
Pages to are hidden for
"HW 3 Homework Relational Algebra 50 points COSC 578 Dr Karne Specify the following queries on"Please download to view full document