CS 445 Schedule
|
Date
|
Topic
|
Notes
|
Assignments
|
|
| Jan 28 | Introduction to Databases | Definition of Terms | Overview (Chapter 1) | PDF
Project Ideas |
page 23: 1.2 , 1.6 (due Feb 8) page 52: 2.2 (1-5) |
|
| Jan 30 |
ER Diagrams (Chapter 2) | Original
ER Diagram Paper |
||
| Feb 1 |
ER Diagrams, Exercise 2.3, page 52 in class | |
|
|
| Feb 4 | Finish 2.3 | In Class ER Diagram Example | |
See Criminal Record
assignment on Moodle |
|
| Feb 6 |
In Class ER Diagram Example | |
|
|
| Feb 8 |
The Relational Model [Chapter 3 through 3.3.1] | PDF MySQL Docs Data Types SQL Statements |
page 95: 3.1, 3.4, 3.5, 3.6 (Due Feb 15) Floats Linux Skills |
|
| Feb 11 |
ER/Database Translations [All of sections 3.5.*] | Assignment One | ||
| Feb 13 |
Introduction to MySQL | SQL Basics (LAB) | [Sections 3.4/3.6/3.7] | PDF
ER Diagram Create Database |
|
|
| Feb 15 |
SQL Basics (LAB) | page 95: 3.8, 3.9, 3.10 (Due Feb 25) |
||
| Feb 18 |
SQL Basics (LAB) | Assignment One Data | Assignment One ER Diagram Due | |
| Feb 20 |
Advanced SQL: Control Flow | Having | Trigger | Binary Data | Stored Procedures | |
GROUP ASSIGNMENTS Design Doc/Presentation Details |
|
| Feb 22 |
Indexes, Joins, SQL | |
||
| Feb 25 |
Exam Review |
Review Sheet |
||
| Feb 27 |
Exam |
|
|
|
| Mar 1 |
ER to SQL Practice |
|
||
| Mar 4 |
Normalization |
Assignment One Due |
||
| Mar 6 |
Normalization | |
Homework: p 643 19.1 1,2,5,6 19.2 1-3 19.10 1-3 DUE: Mar 15 |
|
| Mar 8 |
Normalization |
MVD Paper | MVD2 |
Database Topic Due | |
| Mar 11 |
Normalization Practice | Practice |
Presentation
Rubric |
|
| Mar 13 |
Web enabled database architecture |
MySQL | Apache | PHP Aptana |
PDF Web Arch Aptana Guide (on campus only) |
|
|
| Mar 15 |
Web enabled database architecture | MySQL | Apache | PHP | Open
Source Bridge Topics Design Docs Due |
||
| Mar 18 |
Web enabled database architecture | MySQL | Apache | PHP | |
||
| Mar 20 |
Web enabled database architecture | MySQL | Apache | PHP | PDF |
|
|
| Mar 22 |
Presentations | |
|
|
| Mar
25 |
SPRING BREAK |
|
|
|
| Mar
27 |
|
|
||
| Mar
29 |
|
|
||
| Apr 1 |
Relational Algebra | page: 127: 4.1, 4.2, 4.3 (sub parts: 2,4,8,10, relational algebra only) Due Apr 12 | ||
| Apr 3 |
Relational Algebra | |
||
| Apr 5 |
Exam Review |
|
||
| Apr 8 |
Exam |
|
|
|
| Apr 10 |
Indexing/Storage | InnoDB MySQL Presentations Past MySQL Confs |
||
| Apr 12 |
Query Evaluation | page
300: 8.1, 8.3 page 418: 12.1 [2,4], 12.2, 12.4 [1-2] (Due Apr 26) |
||
| Apr 15 |
Query Evaluation | |
MySQL Database Due - SQL create statements |
|
| Apr 17 |
In
Class Lab |
|
||
| Apr 19 |
SQLite Cake PHP Also Chapter 7 |
SQLite Cake PHP |
||
| Apr 22 |
Web Data (Lab) |
Moodle Docs |
MySQL
Database - SQL insert statements - SQL select statements (5) |
|
| Apr 24 |
NO CLASS - Senior Projects Day |
|
|
|
| Apr 26 |
MARSH
HALL First Day of NoSQL Database Presentations Riak MongoDB / CouchDB |
PDF Structured Data on the Web MapReduce MapReduceExamples Seven Databases In Seven Weeks |
|
|
| Apr 29 |
HBase Neo4J |
|||
| May 1 |
Redis | |
|
|
| May 3 |
Final Presentations
PersonaCombat Medical Game Movies |
Guidelines Rubric |
Web Interface Due Presentation Slides Due |
|
| May 6 |
Review | |
||
| May
11 SATURDAY |
Final Exam 8:30 am - 11:00 am |