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