|
Week/Day |
Date |
Lecture |
Topic |
Chapter/Section Readings |
Assignments |
|
|
|
|
|
|
|
Out |
Due |
|
1Tue |
01/16/07 |
1 |
Introduction. |
|
|
|
|
1Thu |
01/18/07 |
2 |
ER Model |
|
|
|
|
2Tue |
01/23/07 |
3 |
Relational Model |
3.1-3.3 |
|
|
|
2Thu |
01/25/07 |
4 |
Relational Schema Design |
3.4-3.7 |
|
|
|
3Tue |
01/30/07 |
5 |
Relational Schema Design II |
|
|
|
|
3Thu |
02/01/07 |
6 |
Relational Schema Design III |
|
|
|
|
4Tue |
02/06/07 |
7 |
Intro to PHP with Mysql |
|
HW#1 |
Project stage 0 |
|
4Thu |
02/08/07 |
8 |
Relational Algebra II |
5.1-5.4 |
|
|
|
5Tue |
02/13/07 |
9 |
Relational Algebra III |
|
|
|
|
5Thu |
02/15/07 |
10 |
Bag Semantics, PHP with ORACLE, SQL Queries |
6.1-6.3 |
HW#2-Part 1 |
HW#1; graduate project stage 1 |
|
6Tue |
02/20/07 |
11 |
SQL II: Queries |
|
|
|
|
6Thu |
02/22/07 |
12 |
SQL III: Aggregation |
6.4 |
project stage 2 |
|
|
7Tue |
02/27/07 |
13 |
SQL: DB Modification, Definition, Views |
6.5-6.7 |
HW#2-Part 2 |
HW#2-Part 1 |
|
7Thu |
02/29/07 |
14 |
SQL: Constraints and triggers |
7 |
|
|
|
8Tue |
03/06/07 |
15 |
System aspects:PHP interface to DBMS |
(8.1-8.4) |
|
HW#2-Part 2 |
|
8Thu |
03/08/07 |
16 |
Overflow / Midterm review |
|
|
|
|
9Tue |
03/13/07 |
|
Midterm exam 7pm.Bring UIUC PhotoId |
|
|
|
|
9Thu |
03/15/07 |
17 |
Storage and Representation |
11.1-11.4, 11.6-11.8, 12 |
|
graduate project stage 2 |
|
|
03/17-03/25 |
|
Spring break vacation. No class. |
|
|
|
|
10Tue |
03/27/07 |
18 |
Storage II: Sorting and Indexing |
|
|
|
|
10Thu |
03/29/07 |
19 |
Indexing II |
13 |
HW#3 |
project stage 3 |
|
11Tue |
04/03/07 |
20 |
Processing |
|
|
|
|
11Thu |
04/05/07 |
21 |
Processing |
15.1-6 |
|
|
|
12Tue |
04/10/07 |
22 |
Processing Review |
16 |
|
HW#3 |
|
12Thu |
04/12/07 |
23 |
Query Optimization |
|
|
|
|
13Tue |
04/17/07 |
24 |
Query Optimization continued |
|
HW#4 |
graduate project stage 3 ; project stage 4 |
|
13Thu |
04/19/07 |
25 |
Transaction Management |
|
17 |
|
|
14Tue |
04/24/07 |
26 |
SQL Injection and security aspects of web applications |
|
|
project stage 5 |
|
14Thu |
04/26/07 |
27 |
Guest lecture: Data mining and Distributed databases. |
|
|
HW#4 |
|
15Tue |
05/01/07 |
28 |
Summary and Beyond |
|
|
graduate project stage 4 |
|
|
Exam week |
|
Final exam 1:30-4:30,Friday, May 4 |
Please bring photoID, an eraser, pencil and pen. |
||