| Week |
Day |
Topic(s) |
Links/ Slides |
Readings |
Quizzes |
Week 1 |
Oct. 29, 2013 |
Intro. & Logistics |
Intro, Logistics |
Chapter 1 |
|
| Oct. 31, 2013 |
ER-Model (Part 1) |
ER-Part 1 |
Chapter 4.1 (Except 4.1.10 & 4.1.11) |
||
| Nov. 1, 2013 |
ER-Model (Part 2) |
ER-Part 2 |
Sections 4.1.10, 4.1.11, 4.2 |
||
Week 2
|
Nov. 4, 2013 |
ER-Model (Part 3) |
ER-Part 3 |
Sections 4.3, 4.4 |
|
| Nov. 5, 2013 | ER-Good Practice Guidlines |
Quiz 1
|
|||
| Nov. 7, 2013 | Relational Model | Relational Model |
Sections 2.1, 2.2, 2.3 | ||
| Nov. 8, 2013 | Mapping between ER & Relational Models | MappingRules |
Sections 4.5, 4.6.1 | ||
Week 3
|
Nov. 11, 2013 | Relational Algebra (Part 1) | Algebra 1 |
Sections 2.4 | |
| Nov. 12, 2013 | Relational Algebra (Part 2) | Algebra 2 |
Sections 5.1 | ||
| Nov. 14, 2013 | Relational Algebra (Part 3) | Algebra 3 |
Sections 5.2 | Quiz 2 | |
| Nov. 15, 2013 | SQL (Part 1) | SQL 1 |
Sections 6.1, 6.2 | ||
Week 4
|
Nov. 18, 2013 | SQL (Part 2) | SQL 2 |
Sections 6.3 | |
| Nov. 19, 2013 | Revision for Midterm Exam | In Blackboard Sys |
|||
| Nov. 21, 2013 | Midterm Exam |
In Blackboard Sys | |||
| Nov. 22, 2013 | SQL (Part 3) |
SQL 3 |
Section 6.3, 6.5 |
||
Week 5
|
Nov. 25, 2013 | Advanced SQL: Views + Triggers | Advanced SQL 1 Triggers: More Slids |
Sections 8.1, 7.5 |
|
| Nov. 26, 2013 | Advanced SQL: Triggers & Assestions | Section 7.5 |
|||
| Nov. 28, 2013 | Thanksgiving Break
|
||||
| Nov. 29, 2013 | |||||
Week 6
|
Dec. 2, 2013 |
Advanced SQL: Cursors & Stored Procedures |
Advanced SQL 2 |
Sections 7.4, 9.4 |
|
| Dec. 3, 2013 | JDBC |
JDBC |
Section 9.6 |
||
| Dec. 5, 2013 | Functional Dependencies (Part 1) |
FDs-1 |
Section 3.1 |
Quiz 3 | |
| Dec. 6, 2013 | Functional Dependencies (Part 2) | FDs-2 |
Section 3.2 | ||
Week 7
|
Dec. 9, 2013 | Normalization (Part 1) |
Normalization 1 |
Sections 3.3, 3.4 |
|
| Dec. 10, 2013 | Normalization (Part 2) |
3NF |
Section 3.5 |
||
| Dec. 12, 2013 | XML Data Model (Part 1) |
XML |
Sections 11.1 & 11.2 |
||
| Dec. 13, 2013 | XML Data Model (Part 2) |
XML 2 |
Quiz 4
|
||
Week 8
|
Dec. 16, 2013 | Revision for Final Exam |
|||
| Dec. 17, 2013 | |||||
| Dec. 19, 2013 |
Final Exam |
||||