Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

HW 3 Homework Relational Algebra 50 points COSC 578 Dr Karne Specify the following queries on by dux15396

VIEWS: 26 PAGES: 1

									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.

								
To top