1. REQUIRED MATERIAL:

1.1. From the textbook (Ramakrishnan and Gehrke's "Database Management Systems", 3rd Edition.)

• Before the midterm:
• Chapters 1, 2, 3, 4, 8, 10: all sections
• Chapter 5: up to (and including) 5.6
• Chapter 9: all except 9.2
• After the midterm
• Single-table query processing (not in book)
• Chapters 12, 13, 14, 15 (plus the System R optimizer), 16, 17, 18: all sections
• Chapter 19: Sections 19.1 - 19.7
• Chapter 20: Sections 20.1 - 20.10

1.2. Foils

2. Additional information:

• The exam questions will be very similar to the exercises in the textbook.
• We have the same rules as in the midterm: No aids in any form are allowed.
• The exam is comprehensive, but most of the questions will be on the material after the midterm.

3. Previous Exams:

• Spring 2003