Day
|
Topic(s)
|
Links
|
Readings
|
Comments
|
10/25/2011
|
Intro., Logistics, ER Model
|
Intro., Logistics, ER Model -Part1
|
Chapter 1, Chapter 4.1 (Except 4.1.10 & 4.1.11)
|
|
10/28/2011
|
ER Model - Part 2
|
ER Model-Part2
|
Sections 4.1.10, 4.1.11, 4.2, 4.3, 4.4
|
|
11/01/2011
|
Relational Model & Mapping between ER & Relational models
|
Relational, ER-Mapping
|
Sections 2.1, 2.2, 2.3, 4.5, 4.6.1
|
|
11/04/2011
|
Relational Algebra
|
Relational Algebra
|
Sections 2.4, 5.1, 5.2
|
|
11/08/2011
|
Relational Algebra-Part 1 & Normalization- Part 1
|
Algebra-Part2, Normalization-1
|
Sections 5.2, 3.1, 3.2
|
|
11/11/2011
|
Normalization-Revisit, 3NF
|
Normalization-Revisit, 3NF
|
Sections 3.3, 3.4, 3.5
|
|
11/15/2011
|
3NF-Part2, SQL Query Langauge
|
3NF-Part2, SELECT Statement
|
Sections 3.5, 6.1, 6.2
|
|
11/18/2011
|
Revision
|
Revision, Revision-Sol, Quiz
|
|
|
11/22/2011
|
Midterm Exam
|
Midterm (Solution in blackboard)
|
|
|
11/25/2011
|
Thanksgiving Break
|
|
|
|
11/29/2011
|
SQL-Part 2, Views, Triggers
|
SQL-Part2, Advanced SQL
|
Sections 6.3, 6.4, 7.5, 8.1
|
|
12/02/2011
|
Triggers, Assertions, Cursors, Stored Procedures, ODBC/JDBC
|
Advanced SQL-Part2
|
Sections 7.4, 7.5, 9.4, 9.6
|
|
12/06/2011
|
Intro. to Advanced Topics: Transactions & Indexes
|
Advanced topics
|
Sections 6.6, 8.3, 8.4
|
|
12/09/2011
|
Revision
|
Revision, Solution
|
|
|
12/13/2011
|
Final Exam
|
|
|
|