| Day |
Topic(s) |
Links |
Readings |
Comments | Quizzes |
| 01/10/2013 |
Intro., Logistics, ER Model | Intro, Logistics, ER-Model |
Chapter 1, Chapter 4.1 (Except 4.1.10 & 4.1.11) |
||
| 01/14/2013 |
ER Model - Part 2 | ER-Part 2 |
Sections 4.1.10, 4.1.11, 4.2, 4.3, 4.4 |
||
| 01/17/2013 |
Relational Model & Mapping between ER & Relational models | Relational Model, Mapping |
Sections 2.1, 2.2, 2.3, 4.5, 4.6.1 |
Quiz 1 |
|
| 01/21/2013 |
Break (Martin Luther King Day)
|
||||
| 01/24/2013 |
Relational Algebra | Relational Algebra |
Sections 2.4, 5.1, 5.2 |
||
| 01/28/2013 |
Relational Algebra-Part 2 & SQL Query Language | Algebra Part2, SQL Part 1 |
Section 5.2, 6.1, 6.2 |
Quiz 2 | |
| 01/31/2013 |
SQL-Part 2, Views | SQL Part 2, Views |
Sections 6.3, 6.4, 6.5, Section 8.1 |
||
| 02/04/2013 |
Triggers + Revision | Triggers & Assertions + Revision |
Section 7.5 |
Quiz 3 | |
| 02/07/2013 |
Midterm Exam | Midterm exam |
**Solution is in Blackboard System |
Sample Exam | |
| 02/11/2013 |
Triggers, Assertions, Cursors, Stored Procedures | Midterm Summary, Advanced SQL Part 1, Part 2 |
Section 7.4, Section 9.4 |
||
| 02/14/2013 |
Break (Academic Advising Day) |
||||
| 02/18/2013 |
Functional Dependency & Normalization Theory |
Stored Procedures, FDs |
Sections 3.1, 3.2 |
||
| 02/21/2013 |
Normalization Theory |
Normalization Rules |
Sections 3.3, 3.4, 3.5 |
Quiz 4 | |
| 02/25/2013 |
Revision |
Slides |
|||
| 02/28/2013 |
Final Exam | ||||