CSSE333 – Introduction to Database Systems

Winter 2006-07

Schedule Overview

Readings should be completed before class on the day indicated. Homework is due in class on the day indicated. Labs are due at the start of the next lab. Project deliverables are due to the drop box on Angel by 11:59pm, Friday, of the week indicated. Schedule is subject to change, though I'll try to avoid that. (Note: In the Session column, the morning section is Sec. 1 and the afternoon section is Sec. 2.)

Schedule last updated Mon Feb 12.

Week	Session	Reading	HW Due	Project Due	Topics	Slides	Labs
1	1 Sec. 1: Tue Nov 28 Sec. 2: Mon Nov 27 Details	Ch. 1, 2			Databases and Database Users Database Systems and Architecture	Introduction
1	2 Sec. 1: Wed Nov 29 Sec. 2: Wed Nov 29 Details	Ch. 3			Database Systems and Architecture ER Model ER Exercise (Begin Ex. 3.21)	ArchitectureERModel
1	3 Sec. 1: Fri Dec 1 Sec. 2: Thu Nov 30 Details	Skim Ch. 4, Read Ch. 5	1.10, 1.11, 1.12, 2.12, 3.21, 3.22, 3.23 (a,b,c,e)		ER Model Relational Model Converting from ER Diagrams to Relation Schemas	ERtoRelationalModel	1 - SQL Server Overview
2	4 Sec. 1: Tue Dec 5 Sec. 2: Mon Dec 4 Details	Ch. 6			Relational Model Relational Algebra Begin Ex. 6.18 in class	RelationalModelAndAlgebra
2	5 Sec. 1: Wed Dec 6 Sec. 2: Wed Dec 6 Details	Ch. 7.1, 8			Continue Ex. 6.18 in class Introduction to SQL	SQLIntroduction
2	6 Sec. 1: Fri Dec 8 Sec. 2: Thu Dec 7 Details		5.11 (a, b, f, g, i, j), 5.14, 5.17, 6.18 (a-d,g), 7.4		More SQL	SQLContinued	2 - Programming Overview
3	7 Sec. 1: Tue Dec 12 Sec. 2: Mon Dec 11 Details				Creating Databases	MS-CreatingDatabases	3 - Creating and Managing a DB
3	8 Sec. 1: Wed Dec 13 Sec. 2: Wed Dec 13 Details				Table Definitions Constraints	CreatingTablesConstraints
3	9 Sec. 1: Fri Dec 15 Sec. 2: Thu Dec 14 Details	Ch. 8.7	8.7, 8.11 (a-g)		Constraints	For reference see MS-Constraints	4 - Creating Tables and Data Integrity
4	10 Sec. 1: Tue Dec 19 Sec. 2: Mon Dec 18 Details				Introduce the project Exam Review	ProjectIntro Project Description Lightning Talk Instructions
4	11 Sec. 1: Wed Dec 20 Sec. 2: Wed Dec 20 Details				TEST I GIVEN
4	12 Sec. 1: Fri Dec 22 Sec. 2: Thu Dec 21 Details	Ch. 14.1, 14.2		Lightning talk slide	Indexes Microsoft Indexing Video Mid-term plus/delta	Indexes For reference, see MS-Indexes and MS-Indexes2	5 - Indexes
5	13 Sec. 1: Tue Jan 9 Sec. 2: Mon Jan 8 Details				Hand back exams Review plus/delta results Lightning Talks	Plus/delta results
5	14 Sec. 1: Wed Jan 10 Sec. 2: Wed Jan 10 Details	Ch. 8.8			More on indexes Views Finalize project teams Project work	BFViews	6 - Views	Project Work
5	15 Sec. 1: Fri Jan 12 Sec. 2: Thu Jan 11 Details		8.24(a-c); 8.25; 14.14 (a-d)	Initial problem statement; E-R diagram	Curt gone to National Science Foundation meeting		6 - Views	Project Work
6	16 Sec. 1: Tue Jan 16 Sec. 2: Mon Jan 15 Details	Ch. 9			Stored Procedures and Functions	Sproc For reference see also MS-sp and MS-func	7 - Stored Procedures and Functions
6	17 Sec. 1: Wed Jan 17 Sec. 2: Wed Jan 17 Details				Stored Procedures and Functions Project Work		7 - Stored Procedures and Functions
6	18 Sec. 1: Fri Jan 19 Sec. 2: Thu Jan 18 Details			Relation schemas, Security analysis	Database Connectivity JDBC	JDBC	8 - JDBC
7	19 Sec. 1: Tue Jan 23 Sec. 2: Mon Jan 22 Details	Ch. 24.1			Triggers	Triggers For reference see also MS-Triggers	9 - Triggers
7	20 Sec. 1: Wed Jan 24 Sec. 2: Wed Jan 24 Details	Skim Ch. 15			Optimizing Query Performance Analyzing Queries	QueryOpt ExternalSort.mov (a 26MB movie) For reference see also MS-Tuning-1, MS-Tuning-2, and 15-merge_join.avi (a 27 MB movie)	10 - Optimizing Queries
7	21 Sec. 1: Fri Jan 26 Sec. 2: Thu Jan 25 Details			Demo front-end prototypes	Lab and Project Work		10 - Optimizing Queries	Project Work
8	22 Sec. 1: Tue Jan 30 Sec. 2: Mon Jan 29 Details	Skim Ch. 17.1-3, 17.6-7			Transaction and Locks Discuss Sample Reports	Transactions trans.asf (a 60 MB movie) For reference see also MS-Transactions	11 - Transaction Locks
8	23 Sec. 1: Wed Jan 31 Sec. 2: Wed Jan 31 Details	Ch. 10			Creating Interesting Random Data -- a demo Project Work	Download `DataGenerator.xls` from the Samples directory	Project Work
8	24 Sec. 1: Fri Feb 2 Sec. 2: Thu Feb 1 Details			Sample Reports	Functional Dependencies Normalization	Normalization	12 - Normalization Practice
9	25 Sec. 1: Tue Feb 6 Sec. 2: Mon Feb 5 Details				Exam Review Project Work	Exam2Review	Project Work
9	26 Sec. 1: Wed Feb 7 Sec. 2: Wed Feb 7 Details				TEST II GIVEN
9	27 Sec. 1: Fri Feb 9 Sec. 2: Thu Feb 8 Details			Updated Sample Reports, Final Problem Statement	On-line portion of Test II due Hand back written portion of Test II Project Work Review presentation schedule		Project Work
10	28 Sec. 1: Tue Feb 13 Sec. 2: Mon Feb 12 Details				Project Work Course Evaluations		Project Work
10	29 Sec. 1: Wed Feb 14 Sec. 2: Wed Feb 14 Details				Morning Section --- project work time in CSSE labs Afternoon Section Presentations --- IT Asset Tracking --- Tutor Log --- Banks Hardwoods Inc. --- Drugs Are Fun
10	30 Sec. 1: Fri Feb 16 Sec. 2: Thu Feb 15 Details			Final Report, ~~XML Schema~~, Peer Evals	Morning Section Presentations --- the link --- Munchkin --- DDRmy --- FIMS --- The Last Bartender Afternoon Section Presentations --- POD --- Friendaq --- BozeBot --- Cálido --- Poker Players --- Video Game Info.