CSC 440 Database Management Systems

Class Schedule

Notes:

  • This is a tentative schedule, and will be updated. Check frequently.
  • All chapters/sections in reading assignments refer to those in the textbook.
  • Unless otherwise noted, all the presentation materials in this section have been created by Jeffrey D. Ullman. Whenever the PowerPoint slides are not available on this page, they are available at http://infolab.stanford.edu/~ullman/dscb/gslides.html. (Note: These are large files due to the presence of voiceover.)
  • The database schema for some of the in-class examples can be found here.
Date Topics Reading Assignments
Handouts
01/10/08
1. Introduction
Chapter 1 ppt, pdf
01/15/08
2. Database programming basics

JDBC tutorial; Section 8.5

ppt, pdf, firstExample.java

preparation instruction for in-class exercises

01/17/08
Guest Lecture by Dr. Ting Yu
3. Data modeling: entity-relationship approach

Chapter 2

ppt, gifs, pdf
01/22/08
3. Data modeling (cont'd)
   
01/24/08
GuestLecture by Dr. Ting Yu
4. Relational model
Sections 3.1-3.3 ppt, gifs, pdf
01/29/08
4. Relational model (cont'd)
Sections 3.4-3.5 ppt, gifs, pdf
01/31/08
4. Relational model (cont'd)
Section 3.6 ppt, gifs, pdf
02/05/08      
02/07/08
5. Relational algebra
Sections 5.1-5.4 ppt, gifs, pdf
02/12/08
5. Relational algebra (cont'd)
   
02/14/08 5. Relational algebra (cont'd)   Reference solutions to in-class exercises (pdf)
02/19/08
6. SQL
Sections 6.1-6.3 ppt, gifs, pdf
02/21/08
6. SQL (cont'd)
  Reference solutions to in-class exercises
02/26/08
Mid-term review
   
02/28/08
Mid-term Exam (topics 1-6)
   
03/04/08
No Class
(Spring Break)
   
03/06/08
No Class
(Spring Break)
   
03/11/08
Review of mid-term exam
   
03/13/08
6. SQL (cont'd)
Sections 6.4-6.6 ppt, gifs, pdf
03/18/08
No class
   
03/20/08

6. SQL (cont'd)

7. Constraints and triggers

Chapter 7

ppt, gifs, pdf

ppt, gifs, pdf

03/25/08
7. Constraints and triggers (cont'd)
   
03/27/08

 

8. Transactions, security, and authorization in SQL

9. Data storage and index structures (Self-study)

Sections 8.6-8.7

Chapters 11-13
(There is a lot of information for limited time. Focus on the learning objectives.)

ppt1, gifs1, pdf1;
ppt2, gifs2, pdf2

references:
ppt1, pdf1;
ppt2, pdf2;
ppt3, pdf3;
ppt4, pdf4;
ppt5, pdf5

04/01/08
10. Recovery
Chapter 17 ppt, pdf
04/03/08
10. Recovery (cont'd)
   
04/08/08
11. Concurrency control
Chapter 18 ppt, pdf
04/10/08
11. Concurrency control (cont'd)
  Quiz 3 & answer
04/15/08
12. Query execution
Chapters 15-16 ppt1, pdf1;
Quiz 4 & answer
04/17/08
12. Query execution (Cont'd)
Chapters 15-16 Quiz 5 & answer
04/22/08
12. Query execution (Cont'd)
 

ppt2, pdf2

Quiz 6 & answer

04/24/08
Final review
   
04/29/08
Final Exam (8am -- 11am)
   
©2008 Peng Ning . All rights reserved.