| Week |
Date |
Topic |
Reading |
Slides |
Assigned
|
Due
|
| 1 |
Jan
21
|
Martin
Luther King Holiday |
|
|
|
|
|
Jan
23
|
Introduction
|
EN
C. 1 |
PPT
|
background
servey |
|
| 2 |
Jan
28
|
Database
design in ER model |
EN
C. 3 |
PPT |
|
|
|
Jan
30
|
Relational
model and constraints |
EN
2.1-2.2, EN C. 5 |
PPT |
Homework 1 |
background
servey |
| 3 |
Feb 4
|
Relational
algebra I |
EN
C.6.1 -6.3 |
PPT
|
|
|
|
Feb 6
|
Class
canceled due to snow storm
|
|
|
|
|
| 4 |
Feb
11
|
Relational
algebra II |
EN
C.6.4 -6.5 |
PPT |
Homework 2 |
Homework
1 |
|
Feb
13
|
Logical
database design |
EN
C. 7 |
PPT |
|
|
| 5 |
Feb
18
|
Database
design theory I: FD and BCNF |
EN
C. 10 |
PPT |
|
|
|
Feb
20
|
SQL:
query |
EN
C. 8.4 |
PPT |
|
|
| 6 |
Feb
25
|
Embedded
Database Programming
|
EN
C. 9 |
PPT |
|
Homework
2 |
|
Feb
27
|
SQL:
query (II)
|
EN
C. 8.5 |
PPT |
Homework 3 |
|
| 7 |
Mar
5
|
SQL:
NULL, outerjoin, constraints |
EN
C. 8.1-8.3, 8.6-8.9, 17.6
|
PPT |
|
|
|
Mar 7
|
Midterm
review
|
|
PPT |
|
|
| 8 |
Mar
10
|
SQL:
NULL, outerjoin, constraints (II)
|
EN
C. 11 |
PPT
|
Final
Project
Homework 4
|
Homework
3 |
|
Mar
12
|
Midterm
exam (in class) |
|
|
|
|
| 9 |
Mar
17
|
Spring
break
|
|
|
|
|
|
Mar
19
|
Spring
break
|
|
|
|
|
| 10 |
Mar
24
|
CGI
programming
|
|
PPT
|
|
|
|
Mar
28
|
SQL:
NULL, outerjoin, constraints (II) |
EN
C. 11 |
PPT |
|
|
| 11 |
Mar
31
|
Normalization
II
|
EN
C. 10 |
PPT |
|
Homework
4 |
|
Apr 2
|
Disk
|
EN
C. 13
|
PPT |
|
|
| 12 |
Apr 7
|
Indexing
|
EN
C. 14 |
PPT |
|
|
|
Apr 9
|
Query
processing |
EN
C. 15 |
PPT
|
|
|
| 13 |
Apr
14
|
Query
processing II
|
EN
C. 15 |
PPT |
Homework 5 |
|
|
Apr
16
|
Transaction
processing |
EN
C. 17 |
PPT |
|
|
| 14 |
Apr
21
|
Concurrency
control |
EN
C. 18 |
PPT |
|
|
|
Apr
23
|
Concurrency
control II
|
|
|
|
|
| 15 |
Apr
28
|
Recovery
|
EN
C. 19 |
PPT |
Homework 6 |
Homework
5 |
|
Apr
30
|
Data
Mining: association rules |
EN
C. 28 |
PPT |
|
|
| 16 |
May 5
|
Data
Mining: clustering and classification |
EN
C. 28.3-28.4 |
PPT |
|
|
|
May 7
|
Final
review
|
|
PPT |
|
Final
Project
Homework 6
|
17
|
May
16
|
Final
Exam
|
|
|
|
|