|
Lecture |
Day |
Topic Covered |
Assignments/Exams |
|
|
1 |
Aug 22 |
Ch1&2 |
Introduction |
|
|
2 |
Aug 24 |
|
||
|
3 |
Aug 29 |
Ch3 |
The ER Model |
|
|
4 |
Aug 31 |
|
||
|
5 |
Sep 05 |
|||
|
6 |
Sep 07 |
Ch5&7 | The Relational Model |
|
|
7 |
Sep 12 |
|
||
|
8 |
Sep 14 |
Ch6 |
The Relational Algebra and Relational Calculus |
Assignment 1 Due |
|
9 |
Sep 19 |
|
||
|
10 |
Sep 21 |
|
||
|
11 |
Sep 26 |
Ch8&9 | SQL |
|
|
12 |
Sep 28 |
|||
|
13 |
Oct 03 |
Oracle9i Ch2&5 | Oracle SQL & JDBC |
Assignment 2 Due |
|
14 |
Oct 05 |
Exam1 |
|
|
|
15 |
Oct 10 |
Ch10&11 |
Functional Dependencies and Normalization |
|
|
16 |
Oct 12 |
1 page abstract of the term paper Due |
||
|
17 |
Oct 17 |
|
||
|
18 |
Oct 19 |
|
||
|
19 |
Oct 24 |
Ch13 |
Storage |
Assignment 3 Due |
|
20 |
Oct 26 |
|
||
|
21 |
Oct 31 |
Ch14 | Indexing |
|
|
22 |
Nov 02 |
Project Due |
||
|
23 |
Nov 07 |
|
||
|
24 |
Nov 09 | Oracle9i Ch7 | Java Servlets |
|
|
25 |
Nov 14 |
Ch17&18 | Transaction Management and Concurrency Control |
Assignment 4 Due |
|
26 |
Nov 16 | Exam2 |
Assignment 4 Due |
|
|
Nov 21 |
Thanksgiving Holidays |
|
||
|
|
Nov 23 |
|||
|
27 |
Nov 28 |
Cancelled |
Bonus Project Due |
|
|
28 |
Nov 30 |
Ch27&28 |
Data Mining, Data Warehousing and OLAP |
|
|
29 |
Dec 05 |
6710 Presentations (Chunyu, Lindsey, Telvis, Bin) |
|
|
|
30 |
Dec 07 |
6710 Presentations (Chris, Saeideh, Kaushal, Yiwei) |
Assignment 5 & Term Paper Due |
|
|
|
Dec 12 |
Exam3 |
|
|
NOTE: This syllabus represents a general plan and it is subject to change.