Week
|
Day
|
Topic(s)
|
Readings
|
Quizzes
|
Week 1
|
Jan. 16, 2015 - Half 1
|
Intro. & Logistics
|
Chapter 1
|
|
| Jan. 16, 2015 - Half 2
|
ER-Model (Part 1)
|
Chapter 4.1 (Except 4.1.10 & 4.1.11)
|
|
Week 2
|
Jan 20, 2015 - Half 1
|
ER-Model (Part 2)
|
Sections 4.1.10, 4.1.11, 4.2
|
|
| Jan 20, 2015 - Half 2
|
ER-Model (Part 3)
|
Sections 4.3, 4.4
|
|
Jan 23, 2015 - Half 1
|
ER-Good Practice Guidlines
|
|
|
Jan 23, 2015 - Half 2
|
Relational Model
|
Sections 2.1, 2.2, 2.3
|
|
Week 3
|
Jan 27, 2015 - Half 1 |
Cancelled (Weather Conditions)
|
|
|
Jan 27, 2015 - Half 2
|
|
|
| Jan 30, 2015 - Half 1 |
Mapping between ER & Relational Models
|
Sections 4.5 & 4.6.1
|
|
| Jan 30, 2015 - Half 2 |
Relational Algebra (Part 1)
|
Sections 2.4 & 5.1 & 5.2
|
Quiz 1
|
Week 4
|
Feb 3, 2015 - Half 1
|
Relational Algebra (Part 2) |
Sections 5.2
|
|
Feb 3, 2015 - Half 2
|
Relational Algebra (Part 3)
|
Sections 5.2
|
|
| Feb 6, 2015 - Half 1 |
SQL (Part 1)
|
Sections 6.1, 6.2
|
|
| Feb 6, 2015 - Half 2 |
Revision for Midterm
|
|
|
Week 5
|
Feb 10, 2015 - Half 1 |
Midterm Exam
|
|
|
| Feb 10, 2015 - Half 2 |
SQL (Part 2) |
Section 6.3
|
|
| Feb 13, 2015 - Half 1 |
SQL (Part 3) |
Section 6.5
|
|
Feb 13, 2015 - Half 2
|
Advanced SQL: Views + Triggers |
Section 8.1
|
|
Week 6
|
Feb 17, 2015 - Half 1 |
Advanced SQL: Views + Triggers |
Section 7.5
|
Quiz 2
|
| Feb 17, 2015 - Half 2
|
Advanced SQL: Cursors + Stored Proc.
|
Sections 7.4, 9.4
|
|
| Feb 20, 2015 - Half 1 |
Advanced SQL: Cursors + Stored Proc. | Sections 7.4, 9.4
|
|
Feb 20, 2015 - Half 2
|
JDBC |
Section 9.6
|
|
Week 7
|
Feb 24, 2015 - Half 1 |
Functional Dependencies (Part 1) |
Section 3.1
|
|
Feb 24, 2015 - Half 2
|
Functional Dependencies (Part 2) |
Section 3.2
|
|
| Feb 27, 2015 - Half 1 |
Normalization |
|
|
Feb 27, 2015 - Half 2
|
Revision for Final Exam
|
|
Quiz 3
|
Week 8
|
Mar 3, 2015 - Half 1 |
Final Exam
|
|
|
Mar 3, 2015 - Half 2
|
|
|
|
| Mar 6, 2015 - Half 1 |
No Class (Monday Schedule)
|
| Mar 6, 2015 - Half 2
|