Tentative Lecture and Activities Schedule
|
Date |
Topics |
|
Slides |
Project Due |
|
8/22 |
Introduction |
|
1-introduction.ppt |
|
|
8/24 |
continued |
|
|
|
|
8/29 |
ER modeling |
Sec. 6.1-6.5 |
2-ER-a.ppt |
|
|
8/31 |
continued |
|
|
|
|
9/7 |
Weak Entity, EER |
Sec. 6.6-6.8 |
3-ER-b.ppt |
|
|
9/12 |
continued |
|
|
|
|
9/14 |
Relational model, ER to Rel. |
Sec. 2.1, 4.1-4.2, 6.9 |
4-rel-a.ppt |
|
|
9/19 |
continued |
|
|
Part #1 (ER) |
|
9/21 |
Relational Algebra |
Sec. 2.2-2.6 |
5-rel-b.ppt |
|
|
9/26 |
continued |
|
|
|
|
9/28 |
SQL |
Sec. 3.1-3.7 |
6-SQL-a.ppt |
|
|
103 |
continued |
|
|
Part #2 (Rel.) |
|
10/5 |
Exam I |
|
|
|
|
10/12 |
Advanced SQL |
Sec 3.8-3.10, 4.3-4.5 |
7-SQL-b.ppt |
|
|
10/17 |
continued |
|
|
|
|
10/19 |
Good DB design and functional dependency |
Sec. 7.1-7.3 |
8-design-a.ppt |
|
|
10/24 |
continued |
|
|
Part #3 (SQL) |
|
10/26 |
Functional dependency theory |
Sec. 7.4 |
9-design-b.ppt |
|
|
10/31 |
continued |
|
|
|
|
11/2 |
Decomposition and DB design process |
Sec. 7.5, 7.8 |
10-design-c.ppt |
|
|
117 |
continued |
|
|
Part #4 (Load) |
|
11/9 |
Application design and development |
Sec. 8.1-8.5 |
11-web-interface.ppt |
|
|
11/14 |
continued |
|
|
|
|
11/16 |
Triggers and security |
Sec. 8.6-8.8 |
12-security.ppt |
|
|
11/21 |
continued |
|
|
|
|
11/28 |
XML |
|
13-xml.ppt |
|
|
11/30 |
continued |
|
|
Part #5 (Web) |
|
12/5 M |
Demo |
None |
|
|
|
12/14 |
Exam II, Monday 3:30pm |
|
|
|