| Week |
Day |
Topic(s) |
Readings |
Quizzes |
Week 1 |
Oct. 27, 2015 |
Intro. & Logistics |
Chapter 1 |
|
| Oct. 29, 2015 |
ER-Model (Part 1) |
Chapter 4.1 (Except 4.1.10 & 4.1.11) |
||
| Oct. 30, 2015 |
ER-Model (Part 2) |
Sections 4.1.10, 4.1.11, 4.2 |
||
Week 2
|
Nov. 2, 2015 |
ER-Model (Part 3) |
Sections 4.3, 4.4 |
|
| Nov. 3, 2015 | ER-Good Practice Guidlines |
Quiz 1
|
||
| Nov. 5, 2015 | Relational Model | Sections 2.1, 2.2, 2.3 | ||
| Nov. 6, 2015 | Mapping between ER & Relational Models | Sections 4.5, 4.6.1 | ||
Week 3
|
Nov. 9, 2015 | Relational Algebra (Part 1) | Sections 2.4 | |
| Nov. 10, 2015 | Relational Algebra (Part 2) | Sections 5.1 | ||
| Nov. 12, 2015 | Relational Algebra (Part 3) | Sections 5.2 | Quiz 2 | |
| Nov. 13, 2015 | Examples |
|||
Week 4
|
Nov. 16, 2015 | SQL (Part 1) | Sections 6.1, 6.2 | |
| Nov. 17, 2015 | SQL (Part 2) | Sections 6.3 | ||
| Nov. 19, 2015 | SQL (Part 3) | Section 6.3, 6.5 | ||
| Nov. 20, 2015 | Revision for Midterm Exam | |||
Week 5 |
Nov. 23, 2015 |
Midterm Exam | ||
| Nov. 24, 2015 | Cancelled |
|||
| Nov. 26, 2015 | Thanksgiving Break
|
|||
| Nov. 27, 2015 | ||||
Week 6
|
Nov. 30, 2015 |
Advanced SQL: Views + Triggers | Sections 8.1, 7.5 | |
| Dec. 1, 2015 | Advanced SQL: Views + Triggers | Section 7.5 |
||
| Dec. 3, 2015 | Advanced SQL: Triggers & Assestions | Section 7.5 |
||
| Dec. 4, 2015 | Advanced SQL: Cursors & Stored Procedures | Sections 7.4, 9.4 |
Quiz 3
|
|
Week 7
|
Dec. 7, 2015 | JDBC | Section 9.6 | |
| Dec. 8, 2015 | Functional Dependencies (Part 1) | Section 3.1 | ||
| Dec. 10, 2015 | Functional Dependencies (Part 2) | Section 3.2 | ||
| Dec. 11, 2015 | Normalization (Part 1) | Sections 3.3, 3.4 |
Quiz 4
|
|
Week 8
|
Dec. 14, 2015 | Normalization (Part 2) | Section 3.5 | |
| Dec. 15, 2015 | Revision for Final Exam | |||
| Dec. 17, 2015 |
Final Exam |
|||