CMPSC 431W: Introduction to Database Management Systems

Spring 2017 - Time Schedule (Tentative)
Prof. Wang-Chien Lee

 

Schedule will be updated throughout course.

The class will meet three time a week.

Weeks

  Topics

 Reading

Due

Week 1: 01/09/17

  Chapter 1: Introduction 

  Chapter 2: ER Model 

All sections

Project team information due on 01/12/17 (Friday)

Week 2: 01/16/17

  Martin Luther King Day   (01/16/17) - No Class

  Chapter 2: ER Model

All sections, skip 2.7

 

 

Week 3: 01/23/17

  Chapter 3: Relational Model

All Sections

First progress report due on 01/23/17 (Monday).

Week 4: 01/30/17

  Chapter 4: Relational Algebra

Section 4.1-4.2

 

Week 5: 02/06/17

  Project Presentation - Part 1 (02/06/17)

  Chapter 4: Relational Algebra

 

Second progress report due on 02/06/17. 

Project 1 due on 02/06/17. (All progress reports should be included in the appendix)

 

Week 6: 02/13/17

  02/15/17 Midterm 1 (evening exam)

  Chapter 19: Schema Refinement

Section 19.1-19.7, 19-9

 

Week 7: 02/20/17

 

  Chapter 19: Schema Refinement

  Chapter 5: SQL

Section 5.1-5.7

 

Week 8: 02/27/17

  Chapter 5: SQL

  Project Presentation- Part 2 (03/03/17)

 

Third progress report due on 03/03/17. 

Project 2 due on 03/03/17. (All progress reports should be included in the appendix)

Week 9: 03/06/17

  Spring Break - No Class

 

 

Week 10: 03/13/17

  No SQL

  Chapter 6: DB Applications

 

 

Week 11: 03/20/17

  Chapter 6: DB Applications

  Chapter 7: Internet Applications

 

 

Week 12: 03/27/17

  03/27/17: Midterm 2 (evening exam)

  Chapter 8: Storage & Indexing

 

Week 13: 04/03/17

  Project progress review on 04/03/17

  Chapter 8: Storage & Indexing

 

 Fourth progress report due on 04/03/17

Week 14: 04/10/17

 Chapter 12: Query Evaluation

 

 

Week 15: 04/17/17

 Chapter 16: Transaction Management

 

 

Week 16: 04/24/17

  Project Final Demonstration/Review: tentatively scheduled to start on 04/27/17 - details TBA.

 

  Final Project Presentation: tentatively scheduled on evenings of Wednesday 04/26/2017 and Thursday 04/27/17 - details TBA.

 

  No class meetings on 04/26/17 and 04/28/17 (Tentative - time re-allocated for final project demonstration/review and presentation).

 

 

Fifth progress report and the Final Project Report due at the final presentation (All progress reports should be included in the appendix)

Week 17: 05/01/17

 Final Exam 

 TBA