CS 453 - Database Implementation - Winter 2002
Homework Assignments

Homework assignments will be given approximately every 10 days and are due by 6:00 p.m. on the due date. Late assignments will not be accepted. However, you are allowed to drop one of your homework scores, presumably the lowest. 
Assignment #     Due Date


Homework #1   Jan 18
Homework #2   Jan 22
Homework #3   Feb  1
Homework #4   Feb 12
Homework #5   Mar  5
Homework #6   Mar 12
Homework #7   Mar 19
Homework #8   Apr  2
Homework #9   Apr  9
Homework #10  Apr 18
Homework Assignment #1 (Chapter 11: Storage and File Structure). (50 Points Total) (6 Points) Problem #11.3. (12 Points) Problem #11.4. (5 Points) Problem #11.5. (10 Points) Problem #11.7. (12 Points) Problem #11.8. (5 Points) Problem #11.9. Return to top Homework Assignment #2 (Chapter 11: Storage and File Structure). (50 Points Total) (6 Points) Problem #11.10. (8 Points) Problem #11.11. (10 Points) Problem #11.13. (5 Points) Problem #11.14. (5 Points) Problem #11.16. (10 Points) Problem #11.19. (6 Points) Problem #11.20. Return to top Homework Assignment #3 (Chapter 12: Indexing and Hashing). (50 Points Total) (3 Points) Problem #12.1. (12 Points) Problem #12.5. (10 Points) Problem #12.7. (10 Points) Problem #12.12. (8 Points) Problem #12.13. (7 Points) Problem #12.18. Return to top Homework Assignment #4 (Chapter 13: Query Processing). Suggested Solutions:First Page (Postscript) or (JPG) and Second Page (Postscript) or (JPG) format

(50 Points Total) (5 Points) Problem #13.2. (10 Points) Problem #13.4. (15 Points) Problem #13.5. (10 Points) Problem #13.8. (5 Points) Problem #13.9. (5 Points) Problem #13.10. Return to top Homework Assignment #5 (Chapter 14: Query Optimization). (50 Points Total) (5 Points) Problem #14.1. (10 Points) Problem #14.2. (10 Points) Problem #14.3. (9 Points) Problem #14.4. (8 Points) Problem #14.6(a). (8 Points) Problem #14.7. Return to top Homework Assignment #6 (Chapter 14: Query Optimization). (50 Points Total) (15 Points) Problem #14.9. (8 Points) Problem #14.12. (5 Points) Problem #14.13. (12 Points) Problem #14.14(a) & (b) only. (5 Points) Problem #14.15(a). (5 Points) Problem #14.16. Return to top Homework Assignment #7 (Chapter 15: Transactions). (50 Points Total) (10 Points) Problem #15.5. (5 Points) Problem #15.6. (10 Points) Problem #15.8. (5 Points) Problem #15.9. (10 Points) Problem #15.10. (5 Points) Problem #15.11. (5 Points) Problem #15.12. Return to top Homework Assignment #8 (Chapter 16: Concurrency Control). (50 Points Total) (10 Points) Problem #16.2. (5 Points) Problem #16.3. (10 Points) Problem #16.7. (10 Points) Problem #16.9. (10 Points) Problem #16.11. (5 Points) Problem #16.14. Return to top Homework Assignment #9 (Chapter 16: Concurrency Control). (50 Points Total) (5 Points) Problem #16.15. (5 Points) Problem #16.19. (15 Points) Problem #16.20. (15 Points) Problem #16.21 (1st, 3rd, 4th, and 5th only). (5 Points) Problem #16.24. (5 Points) Problem #16.25. Return to top Homework Assignment #10 (Chapter 17: Recovery System). (50 Points Total) (12 Points) Problem #17.3. (6 Points) Problem #17.4. (7 Points) Problem #17.6. (12 Points) Problem #17.8. (5 Points) Problem #17.9. (8 Points) Problem #17.12(a). Return to top Return to CS 453 Homepage

Created December 4, 2000
Updated February 12, 2002