Date | Topic | Assignment | Reading Material |
| Thursday 08/23 | Course organization. Databases and Database Users | ||
| Tuesday 08/28 | Database system concepts and architecture | Read Chapters 1 & 2 | |
| Thursday 08/30 | Database system concepts and architecture | ||
| Tuesday 09/04 | Relational Data model | Read Chapter 3 | |
| Thursday 09/06 | Basic SQL | ||
| Tuesday 09/11 | Basic SQL | Read Chapter 4 | |
| Thursday 09/13 | Basic SQL | ||
| Tuesday 09/17 | More SQL | Read Chapter 5 | |
| Thursday 09/20 | More SQL | ||
| Tuesday 09/25 | More SQL | Homework 1 is due | |
| Thursday 09/27 | Relational Algebra | Read Sections 6.1-6.5 | |
| Tuesday 10/02 | Relational Algebra | Project 1 is due | |
| Thursday 10/04 | Relational Algebra | ||
| Tuesday 10/09 | Entity-Relationship Model | Read Chapter 7 | |
| Thursday 10/11 | Entity-Relationship Model | Homework 2 is due | |
| Tuesday 10/16 | Midterm Exam | ||
| Thursday 10/18 | Enhanced Entity-Relationship Model | Read Chapter 8 | |
| Tuesday 10/23 | Enhanced Entity-Relationship Model | Project 2 is due | |
| Thursday 10/25 | Enhanced Entity-Relationship Model | ||
| Tuesday 10/30 | ER/EER-to-Relational Mapping | Read Chapter 9 | |
| Thursday 11/01 | ER/EER-to-Relational Mapping | Homework 3 is due | |
| Tuesday 11/06 | Basic file structures and hashing | Read Chapter 17 | |
| Thursday 11/08 | Basic file structures and hashing | ||
| Tuesday 11/13 | Indexing | Read Chapter 18 | |
| Thursday 11/15 | Indexing | Homework 4 is due | |
| Tuesday 11/20 | SQL Programming | Read Chapter 13 | |
| Thursday 11/22 | NO CLASS | ||
| Tuesday 11/27 | PHP | Read Chapter 14 | |
| Thursday 11/29 | NO CLASS | Project 3 is due | |
| Tuesday 12/04 | Exam Preparation | ||
| Tuesday 12/11 5:30pm-7:30pm | Final Exam (Comprehensive) |
Last modified: 11/27/12 by Leonidas Fegaras