COP 4540-U01 Homework 4
Spring 2009
Due date: March 23, 2009 (Monday) in class
Problems:
1. [Exercise 6.24] Specify queries (a), (b), (c), (d), and (e) of Exercise 6.16 in both the
tuple relational calculus and the domain relational calculus.
(a) Retrieve the names of employees in department 5 who work more than 10 hours per
week on the 'ProductX' project.
(b) List the names of employees who have a dependent with the same first name as
themselves.
(c) Find the names of employees that are directly supervised by 'Franklin Wong'.
(d) For each project, list the project name and the total hours per week (by all employees)
spent on that project.
(e) Retrieve the names of employees who work on every project.
