Class Outline for Database Systems in Fall 2005

Class Outline for Database Systems in Fall 2006

Course Number: CS 435, Section: 01, CRN: 24833, 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/

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*
28-Aug, Mon	Syllabus, Introduction to Databases	Ch.1.1-6	Refer to your handout, Let's meet, My General Class Guidelines
30-Aug, Wed	Basic Concepts and Architectures	Ch. 2.1-3, 2.5-7.	Refer to your handout
1-Sep, Fri	DBMS at work + DBMS Schema in Color	Ch. 2.4	Read Handout! Happy Labor Day!
4-Sep, Mon	Labor Day holiday (no classes)
6-Sep, Wed	Exam 1 (5%) + Intro to Data Modeling (1)	Ch. 3.1-4	Make sure to read the book and the handout!
8-Sep, Fri	Exam 1 Review, Data Modeling (1) - cont.	Ch. 3.1-4	Read Handouts! Read example in the textbook.
11-Sep, Mon	Data Modeling (2)	Ch. 3.5-9	There can be a Quiz today!
13-Sep, Wed	Review on ER + Practice: My Music Database Design		Refer to your handout - A small homework is due!
15-Sep, Fri	Practice Cont. - My Music Database Design, Intro to EER Model	Ch. 4	Refer to your handout!
18-Sep, Mon	EER Model (2)	Ch. 4	Read about DB design with UML!
20-Sep, Wed	Relational Database Model	Ch. 5
22-Sep, Fri	Review of your homework		Homework is due! Use computers.
25-Sep, Mon	Intro To Relational Algebra	Ch. 6.1-3
27-Sep, Wed	Relational Algebra and Calculus	Ch. 6.3-4
29-Sep, Fri	Relational Algebra and Calculus - cont.	Ch. 6.5-7
2-Oct, Mon	Relational Algebra and Calculus - practice
4-Oct, Wed	Mapping of ER-Model to Relational Mod.	Ch. 7.1-2
6-Oct, Fri	Mapping of EER-Model to Relational Mod.	Ch. 7.2-3
9-Oct, Mon	ABET visit
11-Oct, Wed	Functional Dependencies	Ch. 10.1-2
13-Oct, Fri	Normalization	Ch. 10.3-6, 11-Intr
16-Oct, Mon	Normalization - cont.
18-Oct, Wed	Review
20-Oct, Fri	Exam 2 (15% of final grade)
23-Oct, Mon	Structured Query Language 1	Ch. 8-8.2
25-Oct, Wed	Structured Query Language 2 + PROJECTS	Ch. 8.3-8.4
27-Oct, Fri	Exam 2 Review + Structured Query Language 3	Ch. 8.5-8.8	Projects - Phase 0 is due
30-Oct, Mon	Structured Query Language 3 - cont.	Ch. 8.5-8.8
1-Nov, Wed	Structured Query Language 3 - cont.
3-Nov, Fri	Structured Query Language 4	Ch. 9	SQL Homework Source file for your homework!
6-Nov, Mon	File Organization	Ch. 13
8-Nov, Wed	Indexing Files and B-trees	Ch. 14-14.2
10-Nov, Fri	Veterans' Day (no classes)		Projects - Phase 1 cut off date (no feedback from me after that date!)
13-Nov, Mon	Indexing Files and B-trees - cont.	Ch. 14.3-14.5	SQL homework is due!!!
15-Nov, Wed	More on B+Trees
17-Nov, Fri	Query Processing	Ch. 15
20-Nov, Mon	Query Processing - cont.	Ch. 15
22-Nov, Wed	Thanksgiving Day holiday (no classes)
24-Nov, Fri	Thanksgiving Day holiday (no classes)		Projects - Phase 2 cut off date (no feedback from me after that date!)
27-Nov, Mon	Exam 3 (15% of final grade)		Covers: Everything since the last exam (SQL included)
29-Nov, Wed	Database Tuning	Ch. 16
1-Dec, Fri			Projects - Phase 3 cut off date (no feedback from me after that date!)
4-Dec, Mon	Project Demos PRESENTATION RULES
6-Dec, Wed	Project Demos PRESENTATION RULES		ALL PHASES OF PROJECT ARE DUE! SUBMISSIONS EXPECTED AT THE BEGINNING OF THE CLASS.
8-Dec, Fri	Project Demos PRESENTATION RULES
14-Dec, Thu	6-7:50 PM - FINAL EXAM (20%) in EPS 108