Homework 2: Relational Theory

Start date 25 September, Due beginning of class 2 October.

Exercises from the Book

Complete the following exercises from the book:

  1. 19.8.1 (a), (c)
  2. 19.8.2
  3. 19.12
  4. 19.22
  5. Express the following in Relational Algebra (from Question 4.3):
    1. 4.3.2
    2. 4.3.5
    3. The average cost of each part
    4. The lowest cost supplier of each part

Turning in the assignment

Electronic submission preferred. I'll be setting something up in a bit (suggestions for your choice welcome - WebCT? Others?) For this assignment, send to cs541@mentor.ics.purdue.edu. Pdf is the safest for capturing non-text, please check with me for formats other than txt or pdf. Hard copy is acceptable as well, please hand in at the beginning of class.

Valid XHTML 1.1!