IT420 Course Schedule

Lectures:

	Date	Topic (click on link for slides)	Remarks
1	January 11, 2006	Data modeling with Entity-Relationship model
2	January 13, 2006	Finish Entity-Relationship Model	Read Chapter 5
3	January 18, 2006	The relational model	First part of Chapter 3
4	January 20, 2006	Mapping ER diagrams to relational model	Read Chapter 6
5	January 25, 2006	SQL DDL + DML	Read Chapters 7 and 2
6	January 27, 2006	More SQL	Lab 2 is due today.
7	February 1, 2006	Normalization	Read Chapter 3
8	February 3, 2006	Normalization	Read Chapter 4
9	February 8, 2006	more SQL	Chapter 2, Chapter 7
10	February 10, 2006	SQL – sub-queries, joins
11	February 15, 2006	SQL views	Chapter 7
12	February 17, 2006	SQL triggers, stored procedures	Chapter 7
13	February 22, 2006	6 week exam review
14	February 24, 2006	More SQL triggers, stored procedures	Chapter 7, Chapter 11
15	March 1, 2006	PHP - files
16	March 3, 2006	MySQL
17	March 8, 2006	MySQL - PHP connectivity	createVp5FundTables.txt
18	March 10, 2006	PHP - Write reusable code
19	March 22, 2006	Authentication
20	March 24, 2006	Authentication - part2	Read Chapter 9
21	March 29, 2006	DB administration, Transactions	Chapter 9, Chapter 11
22	March 31, 2006	Transactions – part 2
23	April 5, 2006	IT420_12WeekReview.ppt
24	April 12, 2006	DB Security , Recovery
25	April 14, 2006	Storage and index structures	Chapter 8 – Overview of Storage and Indexing in Ramakrishnan&Gehrke: Database Management Systems
26	April 19, 2006	Index Structures
27	April 21, 2006	Intro to XML	Chapter 13
28		Data warehousing and decision support Guest speaker
29	April 26, 2006	Ethics EthicsQuestions.doc
30	April 28, 2006	Wrap-up, review

Labs:

	Date	Topic	Remarks	Solutions
1	January 10, 2006	Introduction to DB, Intro to Access	Access Tutorial
2	January 17, 2006	ER Modeling	Lab 1 Due Today. Lab 2 (ER Modeling lab) due on January 27.	Lab2_ERModeling_Solutions
3	January 24, 2006	Database design: ER to relational model	Lab 3 (ER To Relational model) due on January 31.
4	January 31, 2006	SQL	Lab 4 (SQL) due on February 7, 2006. InstructionsForDatabaseConnection.doc	Lab4_SQL_Solutions
5	February 7, 2006	Normal forms lab	Lab5_1NF.sql
6	February 14, 2006	6 week exam
7	February 21, 2006	SQL Views LAB	sqlserver_arena.sql	Lab7_SQLViews_Solutions
8	February 28, 2006	PHP slides PHP Lab Intro	vp5order_start.html	Lab8_PHPintro_Solutions
9	March 7, 2006	PHP files, MySQL		Lab9_PHPfiles_MySQL_Solutions
10	March 21, 2006	Lab_PHP_MySQL_connection.doc	SampleDatabaseApplication_songs.doc	Lab10_PHP_MYSQL_Connection_Solutions
11	March 28, 2006	Project2 part1 - Authentication Lab11_SQLQueries.doc		Lab11_SQL_Queries_Solutions
12	April 4, 2006	Locks, Transactions	MarciaTables.sql
13	April 11, 2006	Project 2 part 2
14	April 18, 2006	Project 2 part 3	nclcaDB.sql sampleHTML.html
15		Online processing, XML lab, Web services