|
Week |
Date |
Topic |
Reading Assignment* |
Hwk. / Programming / Project Assignment |
|
8/16 |
Introduction to Databases & Database Environment |
1 |
- |
|
|
1 |
8/21 |
- |
||
|
8/23 |
Database Environment. |
2 |
HW1, MP1 |
|
|
2 |
8/28 |
- |
||
|
8/30 |
The Relational Model |
3 |
HW2, MP2 |
|
|
3 |
9/4 |
- |
||
|
9/6 |
Relational Algebra and Relational Calculus |
4 |
HW3, MP3 |
|
|
4 |
9/11 |
- |
||
|
9/13 |
SQL: Data Manipulation |
5 |
HW4, MP4 |
|
|
5 |
9/18 |
- |
||
|
9/20 |
SQL: Data Definition |
6 |
|
|
|
6 |
9/25 |
- |
||
|
9/27 |
|
|
- |
|
|
7 |
10/2 |
HW5, MP7 |
||
|
10/4 |
midterm (1-6) |
|
- |
|
|
8 |
10/9 |
Access and Oracle |
8 |
HW6, MP5 |
|
10/11 |
|
|
- |
|
|
9 |
10/16 |
Database Planning, Design, and Administration |
9 |
HW7, MP6 |
|
10/18 |
|
D01 |
||
|
10 |
10/23 |
Normalization |
13 |
HW8, MP8 |
|
10/25 |
no class |
- |
||
|
11 |
10/30 |
Fact-Finding Techniques |
10 |
- |
|
11/1 |
HW12, MP9, D02 |
|||
|
12 |
11/6 |
Entity-Relationship Modeling |
11 |
HW9, MP10, D03 |
|
11/8 |
|
|
- |
|
|
13 |
11/13 |
Enhanced Entity-Relationship Modeling |
12 |
HW10, D04 |
|
11/15 |
|
- |
- |
|
| 14 |
11/20 |
|
- |
MP11, D05 |
|
|
11/22 |
no class |
|
|
| 15 |
11/27 |
Methodology - Conceptual Database Design |
15 |
- |
|
|
11/29 |
|
HW11, MP12, D06 |
|
| 16 |
12/4 |
- |
||
|
12/6 |
Project Presentations |
HW13, MP13, D07 |
||
|
- |
12/11 |
Final Examination (Tuesday) -3:10-5:00 |
- |
- |
