=========================preview======================
(IELM230)asgt4.pdf
Back to IELM230 Login to download
======================================================
IELM 230 Industrial Data Systems, Fall 2005
Assignment 3. Max score: 16. Due Date: Nov 16, 2005

Relational Algebra

For each of the following questions, please use the Employee-Department-Projects Database tables that you also used in your lab. In each question, write the RA expression(s) to give the required answer, and the expected output.

Q1. Report the Last Name and Address of Employees who are not in Dept 5.

Q2. Report the Last Name and Address of Employees who are not in the Research dept.

Q3. Report the full name of all department managers.

Q4. Report the last names of all employees involved in a project in Houston.

Q5. Report SSN and Last name of all employees whose supervisor is female.

Q6. Report the Last name of managers who do not supervise any employee.