Database Management Systems

Question 1. (16 points) Exercise 8.16 (a, c, e and i) on pages 281 - 282. Specify the follow-ing queries on the COMPANY relational database schema shown in Figure 5.5 using the relational algebra operators. Aslo show the result of each query as it would apply to the database state of Figure 5.6.

a. Retrieve the names (rst and last names) of all employees in department 5 who work more than 10 hours per week (i.e., WORKS ON.HOURS > 10) on the ProductX project. c. Find the names of all employees who are directly supervised by Franklin Wong.

e. Retrieve the names of all employees who work on every project.

i. Find the names and addresses of all employees who work on at least one project located in Houston but whose (employees) department has no location in Houston.

Question 2. (12 points) Specify all above queries in Question 1 in tuple relational calculus.

Question 3. (6 points) Specify queries (a) and (c) in Question 1 in domain relational calcu-lus.