CS 445 Schedule
|
Date
|
Topic
|
Notes
|
Assignments
|
| Aug 31 | Introduction to Databases | Definition of Terms | Overview [1] | PDF |
page 23: 1.2, 1.6 (Due Sep 9) |
| Sep 2 | ER Diagrams | PDF |
page 52: 2.2 (1-5) (Due Sep 14) Homework Instructions Project Ideas! |
| Sep 4 |
|||
| Sep 7 |
|||
| Sep 9 |
|||
| Sep 11 |
In Class ER Diagram Example | ER Diagram Example | |
| Sep 14 |
The Relational Model [3] | PDF |
Homework |
| Sep 16 | ER / DB Translations | ||
| Sep 18 | |||
| Sep 21 | NO CLASS |
||
| Sep 23 | Introduction to MySQL | SQL Basics (LAB) | PDF |
Assignment One |
| Sep 25 |
SQL Basics (LAB) | ||
| Sep 28 | SQL Basics (LAB) | Assignment
One Data |
|
| Sep 30 |
Exam Review
|
Assignment
One ER Diagram Due Solution Exam 1 Study Guide |
|
| Oct 2 | Midterm 1 | ||
| Oct 5 |
Indexes | Normalization | PDF |
|
| Oct 7 |
Normalization | Design
Doc/Presentation Details |
|
| Oct 9 |
|||
| Oct 12 |
Normalization | Assignment One Due Database Topic Due |
|
| Oct 14 |
Normalization | Homework:
p 643 19.1 1,2,5,6 19.2 1-3 19.10 1-3 DUE 10/26 11:59pm(GoogleDoc) |
|
| Oct 16 |
Normalization | ||
| Oct 19 | Relational Algebra |
||
| Oct 21 | Presentations (Marsh) | Design Presentation / Documents Due | |
| Oct 23 |
Presentations (Marsh) | ||
| Oct 26 |
Presentations (Marsh) | |
|
| Oct 28 | Advanced SQL (LAB) | PDF |
|
| Oct 30 | Web enabled database architecture | MySQL | Apache | PHP | phpMyAdmin (LAB) | PDF |
|
| Nov 2 | Web enabled database architecture | MySQL | Apache | PHP | phpMyAdmin (LAB) | ||
| Nov 4 |
Web enabled database architecture | MySQL | Apache | PHP | phpMyAdmin (LAB) | Extra Credit! |
|
| Nov
6 |
Review | Questions ER Diagram |
|
| Nov 9 |
Midterm 2 |
||
| Nov 11 |
Storage and Indexing [8] |
PDF |
|
| Nov 13 | Relational Algebra [4] |
PDF |
|
| Nov 16 | Query Evaluation [12] | PDF |
Homework: Read for Nov 23 Article Stonebraker Questions |
| Nov 18 | SQL Lite |
PDF |
|
| Nov 20 |
Web Data |
PDF |
WebData Examples |
| Nov 23 | The Pathologies of Big Data | Non-Relation Databases: XML / Column-DB / DataWarehouse / Data Mining | ||
| Nov 25 | |||
| Nov 27 | |||
| Nov 30 | Security | MySQL Grant |
PDF |
|
| Dec 2 | Review | Review |
MySQL Database Due |
| Dec 4 |
Final Project Presentations JJ, Jeff, Samm, Ryan G, Ryan B |
Web
Interface Due Presentation Slides Due Presentation Outline |
|
| Dec 7 |
Final Project Presentations Chris, Maggie, Perry, Brandon O, Brandon K |
||
| Monday, December 14 | 8:30
AM to 11:00 AM |