1. HW 1: Disk Storage and Buffer Manager

Due: 9/23

Link: HW 1

2. HW 2: ER Models and RAID

Due: 9/28

Link: HW 2

3. HW 3: Relational Models

Due: 10/07

Link: HW 3

4. HW 4: File Organization

Due: 10/14

Link: HW 4

5. HW 5: B+ Trees

Due: 10/19

Link: HW 5

6. HW 6: Hash Index, Relational Algebra

Due: 11/02

Link: HW 6

7. HW 7: SQL Practice

Due: 11/10

Link: HW 7

8. HW 8: Practice Questions

Due: nothing is due, these are highly recommend for practice

Here are some problems from the textbook that are good practice for the material after Quiz 3. We do not have solutions to these to share with you, but off of the book website are answers to most of the odd numbered problems in the textbook, so you can check some of your answers with those. You should also explore other questions in the book and compare answers with your classmates.

  • Chapter 12: 12.1 parts 1,2,3,5,6,9; 12.2

  • Chapter 13: 13.1

  • Chapter 14: 14.1 (skip 3,5); 14.2; 14.3; 14.4

  • Chapter 15: 15.5

  • Chapter 16: 16.1 (skip terms we didn’t cover); 16.2,; 16.3