|
Week |
Date |
Topic |
|
Assignments/Additional Materials |
|
Part I: Overview |
||||
|
1 |
Aug. 26, Tue |
Ch 1 |
|
|
|
|
Aug. 28, Thu |
The Database Environment |
Ch 1 |
|
|
|
|
|
|
|
|
2 |
Sept. 2, Tue |
Ch 2 |
|
|
|
|
Sept. 4, Thu |
The Database Development Process |
Ch 2 |
|
|
Part II: Database Analysis |
||||
|
3 |
Sept. 9, Tue |
Modeling Data in the Organization |
Ch 3 |
Project Team Composition |
|
|
Sept. 11, Thu |
Modeling Data in the Organization |
Ch 3 |
HW #1 Out |
|
|
|
|
|
|
|
4 |
Sept. 16, Tue |
Case: Modeling Data |
|
|
|
|
Sept. 18, Thu |
Project Practice: Modeling Data for Group Project |
|
HW#1 Due |
|
|
|
|
|
|
|
Part III: Database Design |
||||
|
5 |
Sept. 23, Tue |
Database Design: Logical Database Design and the Relational Model |
Ch 5 |
Project Deliverable #1 due: Company Analysis and enterprise data model. |
|
|
Sept. 25, Thu |
Database Design: Logical Database Design and the Relational Model |
Ch 5 |
HW #2 Out |
|
|
|
|
|
|
|
6 |
Sept. 30, Tue |
Project Practice: Building Relational Model for Group Project |
|
|
|
|
Oct. 2, Thu |
Physical Database Design and Performance |
Ch 6 |
HW #2 Due |
|
|
|
|
|
|
|
7 |
Oct. 7, Tue |
Physical Database Design and Performance |
Ch 6 |
|
|
|
Oct. 9, Thu |
EXAM 1 |
|
|
|
Part IV: Database Implementation |
||||
|
8 |
Oct. 14, Tue |
Setting up and Using MySQL |
|
Project Deliverable #2 due: Company ERD. |
|
|
Oct. 16, Thu |
Introduction to SQL |
Ch 7 |
|
|
|
|
|
|
|
|
9 |
Oct. 21, Tue |
Introduction to SQL |
Ch 7 |
|
|
|
Oct. 23, Thu |
Advanced SQL |
Ch 8 |
HW #3 Out |
|
|
|
|
|
|
|
10 |
Oct. 28, Tue |
Advanced SQL |
Ch 8 |
|
|
|
Oct. 30, Thu |
Project Practice: Building Queries for Group Project |
|
HW #3 Due |
|
|
|
|
|
|
|
11 |
Nov. 4, Tue |
NO CLASS: Election Day |
|
|
|
|
Nov. 6, Thu |
The Client / Server Database Environment |
Ch 9 |
Project Deliverable #3 due: Logical and Physical Design. |
|
|
|
|
|
|
|
12 |
Nov. 11, Tue |
NO CLASS: Veteran’s Day |
|
|
|
|
Nov. 13, Thu |
The Internet Database Environment |
Ch 10 |
|
|
|
|
|
|
|
|
Part V: Advanced Topics |
||||
|
13 |
Nov. 18, Tue |
Database Administration (1) |
Ch 12 |
|
|
|
Nov. 20, Thu |
Database Administration (II) |
Ch 12 |
|
|
|
|
|
|
|
|
14 |
Nov. 25, Tue |
EXAM 2 |
|
|
|
|
Nov. 27, Thu |
NO CLASS: Thanksgiving |
|
|
|
|
|
|
|
|
|
15 |
Dec. 2, Tue |
Project Practice: Connecting PHP to MySQL |
|
|
|
|
Dec. 4, Thu |
Project Practice: Test Database Prototype |
|
Project Deliverable #4: Database Prototype Due |
|
|
|
|
|
|
|
16 |
Dec. 9, Tue |
Project Presentations |
|
|
|
|
Dec. 11, Thu |
Final Project Report Due |
|
|
This schedule is subject to frequent changes. Check it often!