EECS 484: Schedule

EECS 484 (Database Management Systems) Fall 2012

Overview

Schedule

 

Lecture notes for the semester will be posted before the lecture date, but we will try to post material as far in advance as possible. Please print a copy of the notes if you need it during class. But do expect a few last-minute updates. The final version that you are responsible for will be online a day or so after class. Solutions to odd-numbered exercises in the book can be found at the dbbook website.

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 DiscussionHappy 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