|
| Gree
cells denote no class |
|
Class schedule is tentative and is subject to change according to class
progress |
| Slides that appear
before class meeting might have errors and the errors will be fixed
after class meeting |
| Week |
Date |
Topic |
Reading |
Slides |
Assigned
|
Due
|
| 1 |
Jan
19
|
Martin
Luther King Holiday |
|
|
|
|
1
|
Jan
21
|
Introduction
|
RG
1
|
PPT
|
|
|
2
|
Jan
26
|
ER
|
RG
2
|
PPT
|
|
|
2
|
Jan
28
|
Relational
Model
|
RG
3
|
PPT
|
Homework 1
|
Background Survey |
3
|
Feb
2
|
Relational
Model
|
RG
3
|
|
|
|
3
|
Feb
4
|
ER
to Relational Model
|
RG
3
|
PPT
|
|
|
4
|
Feb
9
|
Relational
Algebra
|
RG
4
|
PPT
|
|
|
4
|
Feb
11
|
Relational
Algebra II
|
RG
4
|
|
Homework 2 |
|
5
|
Feb
16
|
Normalization
|
RG
19.1-19.6
|
PPT
|
|
|
5
|
Feb
18
|
|
|
|
|
|
6
|
Feb
23
|
SQL
|
RG
5
|
|
|
|
6
|
Feb
25
|
SQL
II
|
RG
5
|
PPT |
|
Homework 2
|
7
|
Mar
2
|
Midterm
I
|
|
|
|
|
7
|
Mar
4
|
Embedded
SQL programming
|
RG
6 |
PPT
|
Homework 3
Final Project
|
|
8
|
Mar
9
|
CGI,
Lab session I
|
RG
7
|
PPT
|
Lab Seesion I
|
|
8
|
Mar
11
|
CGI
& SQL
|
RG
6, 7
|
|
|
|
9
|
Mar
16
|
Spring
Break
|
|
|
|
|
9
|
Mar
18
|
Spring
Break |
|
|
|
|
10
|
Mar
23
|
Disk
|
RG
8, 9
|
PPT |
|
|
10
|
Mar
25
|
B+-tree
|
RG
10
|
PPT |
|
Homework 3
|
11
|
Mar
30
|
SQL
III
|
RG
5
|
PPT
|
Homework 4 |
|
11
|
Apr
1
|
SQL
IV
|
RG
5
|
PPT |
|
|
12
|
Apr
6
|
Query
Processing
|
RG
13, 14
|
PPT |
|
|
12
|
Apr
8
|
Normalization
II
|
RG
19.6-19.7
|
|
|
|
13
|
Apr
13 |
Midterm
II Review |
|
|
|
|
13
|
Apr
15 |
Transaction
|
RG
16
|
PPT
|
|
|
14
|
Apr
20
|
Transaction
II |
RG
17 |
PPT |
Homework 5 |
Homework 4
|
14
|
Apr
22
|
Data
Mining
|
RG
26
|
PPT |
|
|
15
|
Apr
27
|
Midterm
II
|
|
|
|
|
15
|
Apr
29
|
Data
Mining II
|
RG
26 |
PPT |
|
|
16
|
May
4
|
Data
Mining III
|
RG
26
|
PPT |
|
|
16
|
May
6
|
Class
Review
|
|
PPT |
Homework 6 |
Homework 5
|
|
|