Due: 5/5/99

With this homework, we're trying to give you some practice with a collection of material that will be on the midterm.  There are three parts:

1.  Relational calculus:  Do #1 and #5 from Exercise 8.3 on page 178 of the text.  Write the solutions in both Domain and Tuple relational calculus.  (Some of you did this in the last homework, so you're ahead of the game.  Please turn them in again, though, since we didn't grade them before.)

2.  Dependencies and Normal Forms: On page 431, do #1 and #2 from Exercise 15.3 and all of Exercise 15.4.   (Note it would be great practice for the midterm to work through all questions in 15.3, but you only need to turn in #1 and #2).

3. ER and relational model: Please convert the Bank ER diagram shown below into relational model schema.