CSC 134 Homework 2

CSC 134 Homework 2 - 20 hours per week. (Note: The...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
CSC 134 Spring 2009 Homework 2 (Total: 100 points) Specify the following queries on the database schema shown in the following figure, using the operations of the relational algebra. Submit a file, either .doc or .pdf, to WebCT. (1) Retrieve the department name if the department has one location in ‘Phoenix”. (2) Retrieve the projects (project names), which ‘John Weley’ is working on more than
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 20 hours per week. (Note: The “hours” attribute in the “works_on” relation specifies how many hours per week for the pair of “essn” and “pno”) (3) List all female dependents (first name, last name) if they are the dependents of “CSC” department employees. (“CSC” is department name). (4) Find the names of employees that are directly supervised by 'Mike Miller'....
View Full Document

This note was uploaded on 10/26/2009 for the course CSC CSC 134 taught by Professor Jinyin during the Spring '09 term at CSU Sacramento.

Ask a homework question - tutors are online