Basically, chapters 4 &apm; 5 from the textbook, and chapter 19 on normalization. We have covered the second part of the course, II. Queries. While we talked about some relational-calculus examples, relational calculus is not covered by the test.

Only topics covered both in the reading and in class are fair game. Test #2 is not cumulative, so it does not test the topics covered by Test #1.

1. Normalization: Schema Refinement (Ch.19)
   1. lossless join decomposition
   2. dependency preservation
2. Relational Algebra (Ch.4)
   1. relational algebra operators
   2. queries
3. SQL (Ch.5)
   1. syntax & conceptual model
   2. aggregate operators
   3. NULL values
   4. queries, queries, queries!

Go through the reading and the examples in the textbook. Consider the problems at the end of each chapter and work some of them. (Answers to the odd numbered excercises are available at the textbook's web-site.) Go through the exercises I have provided.

The test will be closed-note, closed-book. You may bring a calculator, but I cannot imagine that you would need one.

There will be space on the text packet for writing answers. I will bring extra paper, in case anyone needs it, to attach.

The test will be for the class lecture time, so 75 minutes.