| 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 ServerInstructions 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 StartAppendix AAppendix BAppendix 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 | ||||||