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