CS 54100: Database Systems

Assignment 2: Relational Algebra

Due beginning of class Friday, 17 February, 2012

Textbook exercises

  1. Exercise 4.2 parts 1,2,4,5,6.
  2. Exercise 4.3 parts 2, 4, 9, 10, 12
  3. Exercise 4.4 part 3

Relational Calculus

Give an example of an unsafe query in tuple relational calculus, on the schema from Exercise 4.3. What would the same query be in relational algebra?

Turning in the assignment

The safest way to turn in the assignment is through Blackboard; this ensures that we know when it is turned in, and protects against loss. However, I realize that some of this is easier to do by hand rather than electronically, so handing in hard copy at the beginning of the class is acceptable as well.


This page last modified .

Valid XHTML 1.1