| Date |
Lecture |
Topic |
Readings |
Comments |
| Tue 1/17 |
1 |
Introduction (pdf) |
Sections 2.1, 2.2, 2.3 for next lecture |
|
| Thur 1/19 |
2 |
ER Diagram (pdf)
|
Sections 2.4, 3.1, 3.2 |
|
| Tue 1/24 |
3 |
ER Diagram / Relational Model (pdf)
|
Sections 3.3, 3.4. Warning: Sections 3.4-3.7 are difficult to read. So make sure
to read well ahead. |
|
|
| Thur 1/26 |
4 |
Translating from ER to Rel. Model (pdf)
| Sections 3.4, 3.5 |
[Fri 1/27] Homework #1 out (due 2/7) |
| Tue 1/31 |
5 |
Schema Design and Refinement (pdf)
| Sections 3.6, 3.7 |
|
| Thur 2/2 |
6 |
Schema Design and Refinement (pdf)
We are using the same slides as in the last lecture! Thus if you already have last
lecture's slides, you don't have to print them again.
| Sections 3.7, 5.2 |
|
| Tue 2/7 |
7 |
Schema Refinement/Rel. Algebra and Calculus (pdf)
| Sections 5.3-5.4 |
Project Stage 1 due: send in group information
Homework #1 in
Homework #2 out (due 2/21) |
| Thur 2/9 |
8 |
Schema Refinement/Rel. Algebra and Calculus (pdf)
| Sections 6.1-6.5 |
|
| Tue 2/14 |
9 |
Relational Algebra (pdf)
| Sections 6.6-7.2 |
|
|
| Thur 2/16 |
10 |
SQL (pdf)
| Sections 7.3-7.6 |
|
| Tue 2/21 |
11 |
More SQL (pdf)
| Sections 8.1-8.4 |
Project Stage 2 due: Initial ER
Homework #2 in
Homework #3 out (due 3/7) |
| Thur 2/23 |
12 |
SQL, Database Modifications (pdf)
| Sections 8.5-8.7 |
|
| Tue 2/28 |
13 |
SQL, Database Modifications, Views (pdf)
| |
|
|
| Thur 3/2 |
14 |
SQL, Constraints and Triggers
Note: we use the slides of previous lecture
|
|
|
| Tue 3/7 |
15 |
Overflow Lecture / Review for Midterm (pdf)
| |
Homework #3 in |
| Thur 3/9 |
- |
MIDTERM (2:00-3:15PM) |
|
|
| Tue 3/14 |
16 |
System Aspects of SQL
(pdf)
|
Sections 11.1-11.4, 11.6-11.8, 12 |
|
|
| Thur 3/16 |
17 |
System Aspects of SQL (cont.) / Storage and Indexing
(pdf)
|
Section 13, skim Section 14 |
Project Stage 3 due: relational schemas and revised ER |
| Tue 3/21 |
- |
SPRING BREAK |
|
|
|
| Thur 3/23 |
- |
SPRING BREAK |
|
|
| Tue 3/28 |
18 |
Data Storage and Indexing
(pdf)
|
Sections 11.1-11.4, 11.6-11.8, 12 (if you haven't read already) |
|
|
| Thur 3/30 |
19 |
Data Storage and Indexing
(pdf)
|
Section 13, skim Section 14 (if you haven't read already) |
|
| Tue 4/4 |
|
CLASS CANCELED!!!
|
|
|
| Thur 4/6 |
20 |
Query Execution
(pdf)
|
Section 15 |
|
| Tue 4/11 |
21 |
Query execution / Query optimization
(pdf)
|
Section 15, first part of Section 16 |
Homework #4 out (due 4/25) |
| Thur 4/13 |
22 |
Query execution / Query optimization
Note: we use the slides of previous lecture
|
Section 15, first part of Section 16 |
|
| Tue 4/18 |
23 |
Query Optimization
(pdf)
|
Section 16 |
Project Stage 4 due: Screen shots |
| Wed 4/19 |
24 |
MAKE-UP CLASS: 2:30pm - 3:45pm in 1310 DCL (NOT 1320 DCL)
Query Optimization
(pdf)
|
Section 16 |
|
| Thur 4/20 |
25 |
Transaction Management
(pdf)
|
Section 17 |
|
| Tue 4/25 |
26 |
Transaction Management
(pdf)
|
Section 17 |
| Thur 4/27 |
27 |
XML/Data Integration
(pdf)
Data Integration
(pdf)
|
Sections 4.6-4.7, Section 20 |
Homework #4 in |
| Tue 5/2 |
28 |
Overflow lecture / Review for Final
(pdf)
|
|
|
Wed 5/3
Thr 5/4 |
|
You need to schedule a time slot for the demo.
More information will be available soon!
|
|
Project Stage 5 (the demo + final writeup) due |
| Mon 5/8 |
- |
FINAL EXAM (1:30-4:30PM) |
|
|