January 2010
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
          1 2
3 4 5 6 7 8 9
10

Week 1 
11

12

Class 1: Course Overview

Read Chapter 1 in "Manga Guide"

Monday Schedule
13

Class 2: Entity-Relationship Model

Read Chapter 3, Part1 in "Manga Guide"
14 15

Lab 1: Access Lab
Access tutorial
16
17

Week 2 
18

MLK Day
19 20

Class 3: More ER Model
21 22

Lab 2: Entity-Relationship modeling

Lab 1 Due
23
24

Week 3 
25

Class 4: Relational Model and ER to Relational

Read Chapter 2 in "Manga Guide"
26

Add Deadline
27

Class 5: ER to Relational
28 29

Lab 3: Relational Model
Instructions to connect to SQL Server
Instructions to connect to MySQL

Lab 2 Due
30
31

Week 4 
           

February 2010
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
  1

Class 6: Normalization

Read Chapter 3, Part 2 in "Manga Guide"
2 3

Class 7: More Normalization
4 5

Lab 4: Normalization lab
6
7

Week 5 
8

Class 8: SQL (lecture during lab on Friday due to SNOW)

Read Chapter 4 in "Manga Guide"
9 10

SNOW DAY
11 12

Lab 5: Basic SQL

Lab 3 Due

Lab 4 Due
13
14

Week 6 

X-week
15

Wash's BDay
16 17

Work on SQL Lab
18 19

Review
20
21

Week 7 
22

6-week Exam

Feedback Due

Lab 5 Due Before Class
23 24

Class 9: PHP Intro
page.inc

Read Chapters 1 and Chapter 6 (up to page 183) in "PHP and MySQL Web Development"
25 26

Lab 6: PHP Intro
Sample Order Form
Frequent PHP Errors
27
28

Week 8 
           

March 2010
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
  1

Class 10: PHP Arrays, Files, Functions
arrays_examples
array_functions.inc
person.inc
getPersonInfo
processPersonInfo
displayPersonsInfo

Read Chapter 3 and 4 in "PHP and MySQL"

Grades Due
2 3

Class 11: PHP and MySQL
Song Class
songPage
Songs table
4 5

Lab 7: PHP and MySQL

Lab 6 Due Before Lab
6
7

Week 9 
8

Class 12: Authentication and Sessions
Session examples
9 10

Class 13: More sessions
Shopping Songs
Song class

Project start
11 12

Lab 8: Shopping Cart

Lab 7 Due Before Lab
13
14

Week 10 
15

Spring Break
16

Spring Break
17

Spring Break
18

Spring Break
19

Spring Break
20
21

Week 11 
22

Class 14: SQL Views
Exercises/ Homework
Read Chapter 4 in "Manga Guide to DB"
23 24

Class 15: SQL Triggers and Stored Procedures
Read Chapter 6 p.185 in "Manga Guide to DB", Chapter 13 p 316 in "PHP and MySQL Web Development"
25

Project Part 1 (responsibilities) Due by COB
26

Lab 9: SQL views, triggers, stored procedures

Lab 8 Due Before Lab
27
28

Week 12 

X-week
29

Review

Project Part 2 Part 2 (Requirements and ER model) Due before class

Feedback Due
30 31

12-week Exam
     

April 2010
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
        1 2

Lab 10: DB security lab
3
4

Week 13 
5

Class 16: Data storage and indexing
Exercises/HW

Read Chapter 5 p.143-148,162-167 in "Manga Guide for DB"
6

Grades Due
7

Class 17: Data storage and indexing
8 9

Lab 11: Indexing

Drop Deadline

Lab 9 Due

Lab 10 Due
10
11

Week 14 
12

Class 18: Ethics Reading (in class quiz): Data misuse
Public Records
We will also discuss The Code of Professional Responsibility
SQL HW
13 14

Project Work

SQL HW Due
15 16

Project work

Lab 11 Due

Project Part 3, 4, 5, and Login Due During Lab
17
18

Week 15 
19

Class 19: ConcurrencyControl/Transactions
Read Chapter 5, pg 125-137, 153-160 in "Manga Guide to DB"
20 21

Class 20: Concurrency Control/Transactions
SQL HW Due Next Monday
22 23

Lab 12: Transactions lab
24
25

Week 16 
26

Class 21: XML
menu files
27 28

Class 22: XML Lab

SQL HW Due
29 30

Project work

Lab 12 Due
 

May 2010
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
            1
2 3

Project Work

Lab 13 Due
4 5

Final Project Presentations
Course Wrap-up Review sheet

Project Due
6

Classes End
7

Start Finals
8
9 10

Final Exam at 1330 in MI200
11 12 13 14

End Finals
15
16 17

Grades Due
18 19 20 21 22
23 24 25 26 27 28

Graduation
29
30 31