This page is our current best idea of how the entire semester will proceed. However, information on this page is likely to change during the semester -- please check the latest version before preparing for class.

Lecture # |
Date |
Topic |
Reading |
Assignments Etc |

1 | Sept 5 | Introduction | Ch.1 | |

Discussion | Sept 7 | Java Tutorial | ||

2 | Sept 10 | ER Model | Ch.2 | Homework 1 Out |

3 | Sept 12 | Relational Model | Ch. 3 | |

Discussion | Sept 14 | Project 1 Intro | Project 1 Assigned; Group Registration due | |

4 | Sept 17 | ER to Relational | Ch. 3 | |

5 | Sept 19 | Relational Algebra | Ch. 4 | |

Discussion | Sept 21 | HW 1 Soln; Project 1 issues | Homework 1 due at start of section | |

6 | Sept 24 | Relational Algebra(contd.) + Relational Calculus | Ch. 4 | Homework 2 Out |

7 | Sept 26 | SQL | Ch. 5 | |

Sept 27 | Project 1 due at 11:55PM | |||

Discussion | Sept 28 | JDBC and Project 2 discussion | Project 2 Assigned | |

8 | Oct 1 | SQL (contd.) and Triggers | Ch. 5 | |

9 | Oct 3 | Database Application Pogramming | Ch 6, except 6.4 and 6.5 | |

Discussion | Oct 5 | HW 2 solutions | Read SQL Handout | Homework 2 due at start of section |

10 | Oct 8 | Normalization and Tuning | Ch. 19 except 19.8, and Ch. 20.7-20.9 | |

11 | Oct 10 | Wrap up for First Half | ||

Oct 11 | Project 2 due at 11:55PM | |||

Discussion | Oct 12 | Exam Review | ||

Oct 15 | No Class | Fall Study Break | ||

Oct 17 | First Exam | |||

Discussion | Oct 19 | Minirel Overview | Project 3 Assigned | |

13 | Oct 22 | Disks and Files | Ch. 9, except 9.2 | |

14 | Oct 24 | Storage & Indexing | Ch. 8 | Homework 3 Out |

Discussion | Oct 26 | Exam solutions | ||

15 | Oct 29 | Tree-Structured Indexing | Ch. 10, except 10.8.1 | |

16 | Oct 31 | Hash-based Indexing | Ch. 11 | |

Discussion | Nov 2 | HW 3 Solutions | Homework 3 due at start of section | |

17 | Nov 5 | Sorting | Ch. 13 | |

18 | Nov 7 | Storage & Indexing (contd.) | Ch. 8 | Homework 4 Out |

Discussion | Nov 9 | Project 4 intro and page counting | Project 4 Assigned | |

Nov 10 | Project 3 due at 11:55PM | |||

19 | Nov 12 | Query Evaluation | Ch. 12, Ch. 14 | |

20 | Nov 14 | Query Evaluation | ||

Discussion | Nov 16 | HW 4 Solutions | Homework 4 due at start of section | |

21 | Nov 19 | Query Optimization | Ch. 15 | Homework 5 Out |

22 | Nov 21 | Transactions | Ch. 16, except 16.6; Ch. 17, up to and including 17.4 | |

No Discussion | Happy Thanksgiving! | |||

23 | Nov 26 | Transactions (contd.) | Ch. 18, except 18.6 and 18.8 | |

Nov 27 | Project 4 due at 11:55PM | |||

24 | Nov 28 | Transactions (contd.) | ||

Discussion | Nov 30 | Review of counting page accesses | ||

25 | Dec 3 | Open Topics | ||

26 | Dec 5 | Wrap up | ||

Discussion | Dec 7 | HW 5 Solutions | Homework 5 due at start of section | |

27 | Dec 10 | Review | ||

Dec 18 | Second Exam |