| Week |
Day |
Topic(s) |
Readings |
Quizzes |
Week 1 |
01/12/2017 |
Intro. & Logistics |
Chapter 1 |
|
| 01/13/2017 |
ER-Model (Part 1) |
Chapter 4.1 (Except 4.1.10 & 4.1.11) |
||
Week 2
|
01/16/2017 | No Class: Martin Luther K. Day |
||
| 01/17/2017 | ER-Model (Part 2) |
Sections 4.1.10, 4.1.11, 4.2 |
|
|
| 01/19/2017 | ER-Model (Part 3) |
Sections 4.3, 4.4 |
||
| 01/20/2017 | ER-Good Practice Guidlines |
Quiz 1 |
||
Week 3
|
01/23/2017 | Relational Model |
Sections 2.1, 2.2, 2.3 |
|
| 01/24/2017 | Mapping between ER & Relational Models |
Sections 4.5, 4.6.1 |
||
| 01/26/2017 | Relational Algebra (Part 1) |
Sections 2.4 |
||
| 01/27/2017 | Relational Algebra (Part 2) |
Sections 5.1 |
||
Week 4
|
01/30/2017 | Relational Algebra (Part 3) |
Sections 5.2 |
|
| 01/31/2017 | Operations on Bags |
Quiz 2 |
||
| 02/02/2017 | SQL (Part 1) |
Sections 6.1, 6.2 |
||
| 02/03/2017 | SQL (Part 2) |
Sections 6.3 |
||
Week 5
|
02/06/2017 | Midterm Exam |
||
| 02/07/2017 | SQL (Part 3) | Section 6.3, 6.5 |
||
| 02/09/2017 | Canceled (Weather Conditions) |
|||
| 02/10/2017 | Nested Queries |
Section 6.3, 6.5 | ||
Week 6
|
02/13/2017 | Advanced SQL: Views + Triggers |
Section 7.5 | |
| 02/14/2017 | Advanced SQL: Views + Triggers | Section 7.5 | Quiz 3 | |
| 02/16/2017 | No Class: Academic Advising Day |
|||
| 02/17/2017 | Advanced SQL: Views + Triggers | Section 7.5 |
|
|
Week 7
|
02/20/2017 | Advanced SQL: Cursors & Stored Procedures | Sections 7.4, 9.4 | |
| 02/21/2017 | JDBC | Section 9.6 | ||
| 02/23/2017 | Functional Dependencies (Part 1) | Section 3.1 & 3.2 | Quiz 4 |
|
| 02/24/2017 | Functional Dependencies (Part 2) |
Section 3.1 & 3.2 |
|
|
Week 8 |
02/27/2017 | Normalization |
Sections 3.3 - 3.5 |
|
| 02/28/2017 | Normalization | Sections 3.3 - 3.5 | ||
| 03/02/2017 | Final Exam |
|||
| 03/03/2017 | ||||