IT420 Spring 2007

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