CSc 4710/6710 Database Systems
Fall 2011
Homework 1
Due: September 8, 2011 (Thursday)

Specify and execute the following queries in relational algebra (RA) using the RA interpreter on the COMPANY database:

  1. List the names of employees in department 5 who work more than 10 hours per week on the ProductX project.
  2. List the names of employees who have a dependent with the same first name as themselves.
  3. List the names of employees who are directly supervised by Franklin Wong.
  4. List the names of employees who work on every project.
  5. List the names of employees who do not work on any project.
  6. List the names and addresses of employees who work on at least one project located in Houston but whose department has no location in Houston.
  7. List the names of department managers who have no dependents.
  8. List the names of employees whose supervisor's supervisor has a social security number of 888665555.
  9. List the name(s) of employee(s) with the lowest salary.
  10. List the names of employees who work in the department that has an employee with the highest salary among all employees.
To access the database on tinman you may include it in the command line as follows: 
java edu.gsu.cs.ra.RA ~raj/company

SUBMISSION INSTRUCTIONS:

Please include all queries in one file, hw1, and submit using the following command: 
sudo handin 1 hw1
You will be prompted for your password; You must see a SUCCESS message for each file submitted. Please include your name at the top of the file for identification purposes.