Contents:

• Overview
• Problems to be Submitted
• Extra Credit

Topic: Relations
Related Reading: Ch. 2-3
Due: 3:10pm, Wednesday 14 September 2005
3:10pm, Friday 16 September 2005

Please make sure you adhere to the policies on academic integrity.

1. (6 points)

   Exercise 2.1 of text (p. 25)
   Your answer should be in the form of a boolean expression for BROTHER-IN-LAW(x,y) which evaluates to true if and only if x is a brother-in law of y.

2. (6 points)

   Exercise 2.2 of text (p. 25)
   Your answers must be valid "CREATE TABLE" statements in SQL. (though you are not required to test them on turing, you may choose to do so!)

3. (8 points)

   Exercise 3.9 of text (p. 67)

5. (2 points)

   Exercise 3.15 of text (p. 68)