|
X
|
W
|
Date in 2008
|
Topic | Readings due | Resources | Assignments due | Projects Due |
|
x
|
1
|
M 1 Sep
|
Introductory Database Concepts | Chapter 1 | University DB (Access) |
choose project | |
|
x
|
2
|
M 8 Sep | Database Planning & Architecture | Chapter 2 | E.F. Codd paper Chen paper |
Lab Exercise 1.1, 1.2;Submit a pdf of the relationships in 1.2, named [lastName]_HW1.pdf by email with subject CSIS601
Lab Exercise 2.1, 2.2, 2.3; submit a pdf of 2.3, named [lastName]_HW2.pdf by email with subject CSIS601 |
Project Deliverable #1 (see pg 50); submit a pdf of your work named [lastName]_D1.pdf by email with subject CSIS601 |
|
x
|
3
|
M 15 Sep | Entity-Relationship Model | Chapter 3 | Read Chen paper and submit 500 - 1000 word summary named [lastName]_HW3.pdf by email with subject CSIS601 | Project Deliverable #2 (see pg 113); submit a pdf of your work named [lastName]_D2.pdf by email with subject CSIS601 | |
|
x
|
4
|
M 22 Sep | Relational Model | Chapter 4 | Exercise 3.8; submit a pdf named [lastName]_HW4.pdf by email with subject CSIS601 | Project Deliverable #3 (see pg 167); create a Google Doc and share it with me bowring@gmail.com | |
|
x
|
5
|
M 29 Sep | Normalization | Chapter 5 | Exercise 4.1, 4.2, 4.3, 4.4, 4.7, 4.9; submit a pdf named [lastName]_HW5.pdf by email with subject CSIS601 | Project Deliverable #4 (see pg 225); | |
|
x
|
6
|
M 6 Oct | MIDTERM | ||||
|
x
|
7
|
M 13 Oct | BREAK | ||||
|
x
|
8
|
M 20 Oct | Normalization | Chapter 5 | Project Deliverable #5 (see pg 285); | ||
|
x
|
9
|
M 27 Oct | DBMS and SQL | Chapter 6 | Exercises 5.5 - 5.9; submit a pdf named [lastName]_HW6.pdf by email with subject CSIS601 | Explore the project tasks on page 372 using MySQL | |
|
x
|
10
|
M 3 Nov | E-ER Model and OR Model | Chapter 7 | Exercises 6.2, 6.9, 6.15 - 6.18, 6.21; submit a pdf named [lastName]_HW7.pdf by email with subject CSIS601 | Project Deliverable #6 (see pg 372) - submit scripts, queries, etc.; | |
|
x
|
11
|
M 10 Nov | Distributed Databases | Chapter 12 | |||
|
x
|
12
|
M 17 Nov | Databases and the Internet | Chapter 13 | Project Instructions | Project Deliverable #7 - submit UML diagram per instructions; | |
| x | 13 | M 24 Nov | Social and Ethical Issues | Chapter 14 | Project Deliverable #8 = Java project that reads your MySQL db into memory using a class structure based on Deliverable #7 and then serializes you data to XML using XSTREAM library. See Instructions. | ||
| 14 | M 1 Dec | Data Warehouses and Data Mining | Chapter 15 | Project Deliverable #9 = Final Submittal. See Instructions. | |||
| 15 | M 8 Dec | Presentations of Projects | Project Deliverable #10 = 15 minute presentation | ||||
|
*
|
M 15 Dec | FINAL EXAM 7:30 - 10:30 DETAILS: http://docs.google.com/Doc?id=dhrsjbhj_221gqzhzpgk | |||||