| Week |
Date |
Session |
Topic |
Textbook |
Assignment |
Project |
| 1 |
01/19 |
1 |
Course Overview |
|
|
|
01/21 |
2 |
Introduction |
CH 1 |
|
|
| 2 |
01/26 |
3 |
Database System Concepts and Architecture |
CH 2 |
|
|
01/28 |
4 |
Data Models: ER |
CH 3 |
|
|
| 3 |
02/02 |
5 |
Data Models: ER |
CH 3 |
|
|
02/04 |
6 |
Data Models: EER |
CH 4 |
|
|
| 4 |
02/09 |
7 |
Data Models: EER |
CH4 |
|
|
02/11 |
8 |
Data Models: Relational |
CH 5 |
|
|
| 5 |
02/16 |
9 |
Data Models: Relational |
CH 5 |
|
Proposal Due |
02/18 |
10 |
Query Languages: Basic SQL |
CH 6 |
|
|
| 6 |
02/23 |
11 |
Query Languages: Basic SQL |
CH 6 |
|
|
02/25 |
12 |
Query Languages: Advanced SQL |
CH 7 |
|
|
| 7 |
03/01 |
13 |
Query Languages: Advanced SQL |
CH 7 |
|
|
03/03 |
14 |
Data Models: ER- and EER-to-Relational Mapping |
CH 9 |
#1 Due &
#2 Assigned |
|
| 8 |
03/08 |
15 |
Query Languages: Relational Algebra (and Relational Calculus) |
CH 8 |
|
|
03/10 |
16 |
Normalization |
CH 14 |
|
|
| 9 |
03/15 |
17 |
Normalization |
CH 14 |
|
|
03/17 |
18 |
Midterm Exam |
|
|
|
| 10 |
03/22 |
19 |
No Class: Spring Break!
|
|
|
|
03/24 |
20 |
No Class: Spring Break! |
|
|
|
| 11 |
03/29 |
21 |
File Structures |
CH 16 |
|
|
03/31 |
22 |
File Stuctures |
CH 16 |
|
|
| 12 |
04/05 |
23 |
Index Structures |
CH 17 |
|
|
04/07 |
24 |
Index Structures |
CH 17 |
|
|
| 13 |
04/12 |
25 |
Data Models: Object and Object-Relational |
CH 12 |
|
|
04/14 |
26 |
Enhanced Data Models |
CH 26 |
|
|
| 14 |
04/19 |
27 |
Big Data: Distributed Databases, NoSQL, and Hadoop |
CH 23-25 |
|
|
04/21 |
28 |
Big Data: Distributed Databases, NoSQL, and Hadoop |
CH 23-25 |
|
|
| 15 |
04/26 |
29 |
XML |
CH 13 |
|
|
04/28 |
30 |
XML |
CH 13 |
#3 Due |
Final Report & Presentation Due |
| 16 |
05/03 |
31 |
IR and Web Search |
CH 27 |
|
|
05/05 |
32 |
IR and Web Search |
CH 27 |
|
|
| 17 |
TBD |
33 |
Final Exam |
|
|
|
