| January 2007 | ||||||
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
| 1 | 2 | 3 | 4 | 5 Class 1: Course Overview, Database Benefits (set 1) Monday Schedule |
6 | |
| 7 Week 1 |
8 Class 2: Entity-Relationship Model (set 2) |
9 Lab 1: Access Lab Access Tutorial |
10 Class 3: Entity-Relationship Model (set 3) Reading: Chapter 5 |
11 | 12 | 13 |
| 14 Week 2 |
15 MLK Day |
16 Lab 2: Entity-Relationship modeling Lab 1 due |
17 Class 4: Relational Model (set 4) Reading: Chapter 3 (pg 71-81) |
18 | 19 | 20 |
| 21 Week 3 |
22 Class 5: ER to Relational (set 5) Reading: Chapter 6 |
23 Lab 3: ER to Relational Instructions to connect to SQL Server Lab 2 due |
24 Class 6: SQL (set 6) |
25 | 26 | 27 |
| 28 Week 4 |
29 Class 7: More SQL (set 7) Reading: Chapter 7, pg 220-234 and Chapter 2 |
30 Lab 4: Basic SQL Lab 3 due |
31 Class 8: Normalization (set 8) |
|||
| February 2007 | ||||||
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
| 1 | 2 | 3 | ||||
| 4 Week 5 |
5 Class 9: Normalization Reading: Chapter 3 |
6 Lab 5: Normalization |
7 Class 10: Review (review topics) Lab 4 due |
8 | 9 Lab 5 due |
10 |
| 11 Week 6 X Week |
12 6 Week Exam Feedback due |
13 Project 1 Appendix A Appendix B Appendix C |
14 Class 11: PHP Intro (set 9) |
15 | 16 | 17 |
| 18 Week 7 |
19 Presidents Day |
20 Lab 6: PHP Intro Order Form PHP Tutorial Frequent PHP Errors |
21 Class 12: PHP Arrays, Files, Functions (set 10) |
22 | 23 | 24 |
| 25 Week 8 |
26 Class 13: PHP and MySQL (set 11) |
27 Lab 7: PHP and MySQL MidStore ER MidStore SQL |
28 Class 14: Authentication & Sessions (set 12) Lab 6 due |
|||
| March 2007 | ||||||
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
| 1 | 2 | 3 | ||||
| 4 Week 9 |
5 Work on Project 1 |
6 Lab 8: PHP sessions - Shopping Cart Lab 7 due |
7 Class 15: SQL views (set 13) Project 1 due |
8 | 9 | 10 |
| 11 Spring Break |
12 Spring Break |
13 Spring Break |
14 Spring Break |
15 Spring Break |
16 Spring Break |
17 |
| 18 Week 10 |
19 Class 16: SQL triggers and stored procedures (set 14) Reading: Chapters 7, 11 |
20 Lab 9: SQL views, triggers, stored procedures IT420_S07_Lab9_sqlserver_arena.sql |
21 Work on Lab 9 Lab 8 due |
22 | 23 | 24 |
| 25 Week 11 |
26 Class 17: Ethics Reading: Data misuse Public Records The Code of Professional Responsibility |
27 Lab 10: DB security lab Lab 9 due |
28 Class 18: Review (review topics) Feedback due |
29 | 30 | 31 |
| April 2007 | ||||||
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
| 1 Week 12 X Week |
2 12 Week Exam |
3 Project 2 Appendix A Appendix B |
4 Class 19: Transactions (set 16) Reading: Chapter 9 |
5 | 6 | 7 |
| 8 Week 13 |
9 Class 20: Transactions/Locks |
10 Lab 11: Transactions |
11 Comp time |
12 | 13 | 14 |
| 15 Week 14 |
16 Work on Project 2 |
17 Work on Project 2 Lab 11 due |
18 Work on Project 2 / SOFs |
19 | 20 | 21 |
| 22 Week 15 |
23 Class 21: Data storage and indexing (set 17) |
24 Work on Project 2 |
25 Class 22: Review and Project Presentations (review topics) Project 2 due |
26 | 27 | 28 |
| 29 Week 16 |
30 Study Day |
|||||
| May 2007 | ||||||
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
| 1 | 2 Final Exam 0755 MI116 (2001/6001), MI118 (4001) |
3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 Grades Due |
11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | 31 | ||