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