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

11

Lab 1: Course Overview

Read Chapter 1
Access Lab
Access tutorial

Monday Schedule
12

Class 1: SQL

Chapter 2
13 14

Class 2: More SQL
15
16

Week 1 
17

MLK Day
18

Lab 1 Due Before Class
19

SQL Practice
Instructions to connect to SQL Server
SQL Data
20 21

Class 3: More SQL
22
23

Week 2 
24

Lab 2: Basic SQL
Madison Imports

Lab Solution
25

Add Course Deadline
26

Class 4: Relational Model and Normalization

Chapters 3, 4
27 28

Class 5: More Normalization
Chapter 4
29
30

Week 3 

Lab 2 Due at 2359
31

Lab 3: Normalization lab

Lab Solution

Relational Model and Normalization Quiz
         

February 2011
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
    1 2

Class 6: Entity-Relationship Model
ER Model Exercises

Chapter 5
3 4

Class 7: More ER Model
5
6

Week 4 
7

Lab 4: Entity-Relationship modeling

Lab 3 Due before lab

Entity-Relationship Model Quiz
8 9

Class 8: ER to Relational
ER to Relational Exercises

Chapter 6, 7
10 11

Class 9: ER to Relational
12
13

Week 5 

X-week
14

Lab 5: ER to Relational Model

Lab 4 Due before lab
15 16

Class 10: More SQL
Review

Feedback Due
17 18

6-week Exam
19
20

Week 6 
21

Wash's BDay
22 23

Class 11: Project Start
Travel Request
Status of funds

Grades Due

Lab 5 Due Before Class
24 25

Class 12: PHP Intro
page.inc
person.inc
getPersonInfo
processPersonInfo
readPersonInfo

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

in lab
26
27

Week 7 
28

Lab 6: PHP Intro
Sample Order Form
Frequent PHP Errors
         

March 2011
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
    1 2

Class 13: PHP Arrays, Files, Functions
arraysExamples
arrayFunctions.inc

Read Chapter 3 and 4 in "PHP and MySQL"

in lab
3 4

Class 14: PHP and MySQL
Song Class
Song Page
Songs table

in lab
5
6

Week 8 
7

Lab 7: PHP and MySQL
Online Store Tables
myConnectDB.inc.ph

Lab Solution

Lab 6 Due before lab
8 9

Class 15: Authentication and Sessions
Session examples

in lab
10 11

Class 16: More sessions
Shopping Songs
Song class

Early Schedule

in lab

Project Part 1 (Requirements and ER model) Due before class
12
13

Week 9 
14

Spring Break
15

Spring Break
16

Spring Break
17

Spring Break
18

Spring Break
19
20

Week 10 
21

Lab 8: Shopping Cart
Online Store Tables

Lab Solution

Lab 7 Due before lab
22 23

Class 17: SQL Stored Procedures
Chapter 7, 10b
24 25

Class 18: SQL Triggers and SQL Views

Project Part 2,3,4 (Relational model, normalization, and MySQL tables) Due before class
26
27

Week 11 
28

Lab 9: SQL stored procedures, triggers and views

Lab Solution
29 30

Class 19: More SQL Views
31    

April 2011
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
          1

More SQL Sub-Queries

Lab 8 Due Before Class (no late submission accepted)

in lab
2
3

Week 12 

X-week
4

Review and Project work

Feedback Due

Lab 9 Due Before Lab
5 6

12-week Exam
7 8

Project work

in lab
9
10

Week 13 
11

Lab 10: DB security lab
lab10.zip

Project login/logout due before lab
12

Grades Due
13

Class 20: ConcurrencyControl/Transactions
Chapter 9, pg 321-335
14 15

Class 21: Concurrency Control/Transactions

Drop Course Deadline
16
17

Week 14 
18

Lab 11: Transactions lab

Lab Solution

Lab 10 Due Before Lab

Project insert/view request due before lab
19 20

Project work

in lab
21 22

Class 22: Data storage and indexing
23
24

Week 15 
25

Lab 12: Indexing

Lab Solution

Lab 11 Due
26 27

Class 23: Ethics Reading (in class quiz): Data misuse
Pandora music
28 29

SOFs, Project work
30

May 2011
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
1

Week 16 
2

Course Wrap-up Review sheet and Project presentations

Project Due
3

Last Day of Classes

Lab 12 Due
4

Class 24:

Reading Day
5

Start Finals
6

Final Exam in MI223 at 1930
7
8 9

Final Exam Alternate in MI200 at 0755
10 11 12

End Finals
13 14

Grades Due
15 16 17 18 19 20 21
22 23 24 25 26 27

Graduation
28
29 30 31