EECS 484: Schedule

EECS 484 (Database Management Systems) Fall 2013

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.

In the readings and assignments columns, when we say Ch.1, we mean Chapter 1 in the textbook. When we say 2-RelationalModel, we mean lecture 2 in the Widom course (you can directly type in the URL https://class.coursera.org/db/lecture/2 ) and the topic name which is used to identify the notes (e.g. http://s3.amazonaws.com/dbclass-resources/docs/pdfs/RelationalModel.pdf ).

Lecture # Date Topic Reading Assignments Etc
1 Sept 4 Introduction Ch.1, 1-CourseIntro  
Discussion Sept 6 Java Tutorial    
2 Sept 9 ER Model Ch.2, Compare to 56-UMLModeling
3 Sept 11 Relational Model Ch. 3 Watch 2-RelationalModel, 30-ConstraintsTriggers, 34-Constraints ; Homework 1 Out
Discussion Sept 13 Project 1 Intro Project 1 Assigned; Group Registration due
4 Sept 16 ER to Relational Ch. 3, Compare to similar material in 29-UMLRelations, which we will not cover Watch 31-ReferentialIntegrity
5 Sept 18 Relational Algebra Ch. 4, roughly through 4.2.4 Watch 4-RelationalAlgebra1
  Sept 19     Homework 1 due at 11:55PM
Discussion Sept 20 HW 1 Soln; Project 1 issues    
6 Sept 23 Relational Algebra(contd.) + Relational Calculus Ch. 4 Watch 5-RelationalAlgebra2. Homework 2 Out
7 Sept 25 SQL Ch. 5, up to 5.2 Watch 6-SQLIntro, 7-SQLSelect, 9-TableVarsSetOps
  Sept 26     Project 1 due at 11:55PM
Discussion Sept 27 JDBC and Project 2 discussion Read SQL Handout Project 2 Assigned
8 Sep 30 SQL (contd.) The rest of Ch. 5 Watch 10-SQLSubQueriesWhere, 11-SQLSubqueriesFromSelect, 12-SQLJoinOperators, 13-SQLAggregation
9 Oct 2 Database Application Pogramming Ch 6, except 6.4 and 6.5  
  Oct 3     Homework 2 due at 11:55PM
Discussion Oct 4 HW 2 solutions    
10 Oct 7 Disks and Files Ch. 9, except 9.2 Watch 14-SQLNulls, 15-SQLModifications
11 Oct 9 Storage & Indexing Ch. 8  
  Oct 10     Project 2 due at 11:55PM
Discussion Oct 11 Project 3 and Postgres Overview   Project 3 Assigned
Oct 14 No Class Fall Study Break  
12 Oct 16 Spill-over material and some review    
Discussion Oct 18 Exam Review    
  Oct 18 First Floor Dow Building Rooms assigned by last name First Exam at 7PM
13 Oct 21 Hash-based Indexing Ch. 11 Homework 3 Out
14 Oct 23 Tree-Structured Indexing Ch. 10, except 10.8.1  
Discussion Oct 25 Exam solutions    
15 Oct 28 Sorting Ch. 13  
16 Oct 30 Storage & Indexing (contd.) Ch. 8  
  Oct 31     Homework 3 due at 11:55PM
Discussion Nov 1 HW 3 Solutions    
17 Nov 4 Query Evaluation Ch. 12, Ch. 14 Homework 4 Out
18 Nov 6 Query Evaluation    
  Nov 7     Project 3 due at 11:55PM
Discussion Nov 8 Canceled   Project 4 Assigned
19 Nov 11 Query Optimization Ch. 15  
20 Nov 13 Transactions Ch. 16, except 16.6; Ch. 17, up to and including 17.4  
  Nov 14     Homework 4 due at 11:55PM
Discussion Nov 15 HW 4 Solutions and Project 4 intro    
21 Nov 18 Transactions (contd.) Ch. 18, except 18.6 and 18.8 Homework 5 Out
22 Nov 20 Open Topics    
Discussion Nov 22 Review of counting page accesses    
23 Nov 25 Open Topics   Project 4 due at 11:55PM
Nov 27 No LectureHappy Thanksgiving!
Nov 29 No DiscussionHappy Thanksgiving!
25 Dec 2 Normalization Ch. 19 until 19.3 Watch 24-RelDesignOverview, 25-FunctionalDependencies, 26-BCNF
26 Dec 4 Normalization (contd.) and Tuning Ch. 19 except 19.8, and Ch. 20.7-20.9 Watch 27-MVDs4NF, 35-NormalFormShortcomings
  Dec 5     Homework 5 due at 11:55PM
Discussion Dec 6 HW 5 Solutions    
27 Dec 9 Review    
  Dec 13 Second Exam