| 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 | |||||