Class Outline for Database Systems in Fall 2005

Course Number: CS 435, Section: 01, CRN: 23139, Credits: 3

Prerequisites: CS 223 or CS 302.

Meetings: Monday, Wednesday, and Friday, 11:00-11:50AM at EPS 108*

Course Web page: http://www.cs.montana.edu/courses/435/

* NOTE: on Oct/19 (Wednesday) we meet at the CS Conference Room! ! !

Roll is here. Your points/grades can be checked here.

ANNOUNCEMENT! Here is a link to software you may possibly consider when working on your projects in future. http://www.fabforce.net/dbdesigner4/

*Date*	*Lecture Topics*	*Assigned Readings*	*Other Assignments*
29-Aug, Mon	Syllabus, Introduction to Databases	Ch.1.1-6	refer to your handout
31-Aug, Wed	Basic Concepts and Architectures	Ch. 2.1-3, 2.5-7.	refer to your handout
2-Sep, Fri	DBMS at work	Ch. 2.4 & Handout!	Happy Labor Day!
5-Sep, Mon	Labor Day holiday (no classes)
7-Sep, Wed	Exam 1 (5%) + Intro to Data Modeling (1)	Ch. 3.1-4
9-Sep, Fri	Exam 1 Review, Data Modeling (1) - cont.	Ch. 3.1-4
12-Sep, Mon	Data Modeling (2)	Ch. 3.5-9
14-Sep, Wed	Practice - My Music Database Design		New homework can be found in "Intro to EER Model"
16-Sep, Fri	Intro to EER Model , Review on ER	Ch. 4
19-Sep, Mon	EER Model (2)	Ch. 4
21-Sep, Wed	Relational Database Model	Ch. 5
23-Sep, Fri	Intro To Relational Algebra	Ch. 6.1-3	Thanks for your Homework!
26-Sep, Mon	Relational Algebra and Calculus	Ch. 6.3-4	Thanks for your Homework!
28-Sep, Wed	Relational Algebra and Calculus - cont.	Ch. 6.5-7
30-Sep, Fri	Relational Algebra and Calculus - practice
3-Oct, Mon	Mapping of ER-Model to Relational Mod.	Ch. 7.1-2
5-Oct, Wed	Mapping of EER-Model to Relational Mod.	Ch. 7.2-3
7-Oct, Fri	Functional Dependencies	Ch. 10.1-2
10-Oct, Mon	Normalization	Ch. 10.3-6, 11-Intr
12-Oct, Wed	Review, Homework Analysis
14-Oct, Fri	Questions session with Stibitz Honorees		Thanks for your Homeworks!
17-Oct, Mon	Structured Query Language 1	Ch. 8-8.2
19-Oct, Wed	Structured Query Language 2	Ch. 8.3-8.4
21-Oct, Fri	Exam 2 (15% of final grade)	Covers: Everything since the last exam, except SQL (i.e. last two lectures)
24-Oct, Mon	Structured Query Language 2 - cont.	Ch. 8.3-8.4	Thanks for your Homeworks!
26-Oct, Wed	Structured Query Language 3	Ch. 8.5-8.8
28-Oct, Fri	Structured Query Language 3 - cont.	Ch. 8.5-8.8
31-Oct, Mon	Structured Query Language 4 PROJECTS	Ch. 9	SQL Homework ! Source file for your homework!
2-Nov, Wed	File Organization	Ch. 13
4-Nov, Fri	Indexing Files and B-trees	Ch. 14-14.2
7-Nov, Mon	Exam 2 Review
9-Nov, Wed	Indexing Files and B-trees - cont.	Ch. 14.3-14.5	PHASE I OF PROJECT IS DUE!
11-Nov, Fri	Veteran's Day holiday (no classes)
14-Nov, Mon	Indexing Files and B-trees - cont.		SQL homework is due!!!
16-Nov, Wed	Query Processing	Ch. 15
18-Nov, Fri	Query Processing - cont.	Ch. 15
21-Nov, Mon	Exam 3 (15% of final grade)		Covers: Everything since the last exam + SQL
23-Nov, Wed			PHASE II OF PROJECT IS DUE!
25-Nov, Fri	Thanksgiving Day holiday (no classes)
28-Nov, Mon	Database Tuning	Ch. 16
30-Nov, Wed	Recovery Techniques	Ch. 19
2-Dec, Fri	REVIEW for final
5-Dec, Mon	Project Demos		ALL PHASES OF FINAL PROJECT ARE DUE!
7-Dec, Wed	Project Demos
9-Dec, Fri	Project Demos
14-Dec, Wed	8-9:50 AM - FINAL EXAM (20%) in EPS 108