January 2009
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
        1 2 3
4

Week 1 
5 6

7

Class 1: Course Overview
8 9

Class 2: Entity-Relationship Model
10
11

Week 2 
12 13

Lab 1: Entity-Relationship modeling
14

Class 3: Relational Model and ER to Relational
15 16

Class 4: ER to Relational
17
18

Week 3 
19

MLK Day
20

Monday Schedule
21

Class 5: Normalization

Add Deadline
22 23

Class 6: Normalization
24
25

Week 4 
26 27

Lab 2: Relational Model
Instructions to connect to SQL Server
Instructions to connect to MySQL
28

Class 7: SQL
29 30

Class 8: More SQL
31

February 2009
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
1

Week 5 
2 3

Lab 3: Basic SQL
YP Squadron

Lab 2 Due
4

comp time
5 6

Review topics
7
8

Week 6 

X-week
9 10

Project Start
Appendix A
Appendix B
Appendix C

Lab 3 Due

Feedback Due
11

6-week Exam
12 13

Class 9: Guest lecture
14
15

Week 7 
16

Wash's BDay
17

Lab 4: PHP Intro
Frequent PHP Errors
Lab Solution
18

Class 10: PHP Intro
page.inc
input_page
process_name_age
read

Grades Due
19 20

Class 11: PHP Arrays, Files, Functions
arrays_Examples
array_functions.inc
21
22

Week 8 
23 24

Lab 5: PHP and MySQL
Online Store Tables
Lab Solution
25

Class 12: PHP, MySQL, and Sessions
Song Class
song_page
Songs table

Lab 4 Due
26 27

Class 13: Authentication & Sessions
28

March 2009
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
1

Week 9 
2 3

Continue PHP-MySQL lab
4

Class 14: SQL Views
5 6

Class 15: SQL Triggers and Stored Procedures

Project Parts 3,4,5,6 Due
7
8

Week 10 
9 10

Lab 6: SQL views, triggers, stored procedures
Lab Solution
11

lab work

Lab 5 Due
12 13

Review
14
15

Week 11 
16

Spring Break
17

Spring Break
18

Spring Break
19

Spring Break
20

Spring Break
21
22

Week 12 
23 24

project work

Lab 6 Due
25

Class 16: Data storage and indexing
26 27

Class 17: Data storage and indexing
28
29

Week 13 

X-week
30 31

Lab 7: Indexing
Lab Solution

Feedback Due

Project Login Due
       

April 2009
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
      1

Class 18: Ethics Reading: Data misuse
Public Records
The Code of Professional Responsibility

Ethics Quiz
2 3

12-week Exam
4
5

Week 14 
6 7

Lab 8: DB security lab
lab8.zip

Grades Due
8

Class 19: ConcurrencyControl/Transactions
9 10

Class 20: Concurrency Control/Transactions

Drop Deadline

Lab 7 Due
11
12

Week 15 
13 14

Lab 9: Transactions lab
Lab Solution

Lab 8 Due

Project Bio Due
15

Project Work
16 17

Class 21: XML
menu files
18
19

Week 16 
20 21

Lab 10: XML Lab
Lab Solution

Lab 9 Due
22

Project Work
23 24

Project Work
25
26 27 28

Final Project Presentations in MI206
Course Wrap-up Review sheet
29

Reading Day

Lab 10 Due

Project Due
30

Start Finals
   

May 2009
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
          1

Final Exam 0755 in MI223
2
3 4 5

Final Exam Alternate Date 0755
6 7

End Finals
8 9

Grades Due
10 11 12 13 14 15 16
17 18 19 20 21 22

Graduation
23
24 25 26 27 28 29 30
31