Class Outline for Database Systems (CS 435) in Fall 2008

Instructor: Dr. Rafal A. Angryk

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 can be checked here.

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

Date	Lecture Topics	Assigned Readings	Other Assignments & Comments
3-Sep, Wed	Syllabus, Introduction to Databases	Ch.1.1-6	Refer to your handout+ Fill out: Let's meet, Read: My General Class Guidelines
5-Sep, Fri	Basic Concepts and Architectures	Ch. 2.1-3, 2.5-7.	Refer to your handout
8-Sep, Mon	DBMS at work	Ch. 2.4	Study handout in detail!
10-Sep, Wed	Intro to Data Modeling (1)	Ch. 3.1-4	Read Handouts. Study examples in the textbook.
12-Sep, Fri	Exam 1 (5%) + Data Modeling (1) - cont.	Ch. 3.1-4	The exact date has been decided! Exam covers: ALL readings from Ch.1&2 + handouts, questions, etc. (especially DBMS Diagram!)
15-Sep, Mon	Data Modeling (2)	Ch. 3.5-9
17-Sep, Wed	Review on ER + Practice: My Music Database Design		There can be a short Quiz on Data Modeling (Ch. 3) today!
19-Sep, Fri	Intro to EER Model	Ch. 4
22-Sep, Mon	EER Model (2)	Ch. 4
24-Sep, Wed	Relational Database Model	Ch. 5
26-Sep, Fri	Relational Database Model - cont. + Intro To Relational Algebra	Ch. 6.1-3
29-Sep, Mon	Intro To Relational Algebra - cont. + Review of your homework	Ch. 6.1-3	Homework is due today!!!
1-Oct, Wed	Relational Algebra and Calculus	Ch. 6.3-4
3-Oct, Fri	Relational Algebra and Calculus - cont.	Ch. 6.5-7
6-Oct, Mon	Relational Algebra and Calculus - practice
8-Oct, Wed	Mapping of ER-Model to Relational Model	Ch. 7.1-2
10-Oct, Fri	Mapping of EER-Model to Relational Model	Ch. 7.2-3
13-Oct, Mon	Functional Dependencies	Ch. 10.1-2
15-Oct, Wed	Functional Dependencies - cont.
17-Oct, Fri	Normalization	Ch. 10.3-6, 11-Intr
20-Oct, Mon	Normalization - cont.		There can be a short Quiz on Functional Dependencies today!
22-Oct, Wed	Review		Homework is due today!!!
24-Oct, Fri	About your projects		Frequent Errors made in projects
27-Oct, Mon	Exam 2 (15% of final grade)		The exact date has been decided! Exam covers: ALL readings from Ch.3-7&10 + handouts, questions, etc.
29-Oct, Wed	Structured Query Language 1	Ch. 8-8.2	How to access MySQL DBMS
31-Oct, Fri	Structured Query Language 2	Ch. 8.3-8.4	SQL Homework is here. SQL script needed for this homework is here.
3-Nov, Mon	Structured Query Language 2 – cont.	Ch. 8.3-8.4	Pre-proposals for your projects are due today!!!
5-Nov, Wed	Structured Query Language 3	Ch. 8.5-8.8
7-Nov, Fri	Structured Query Language 3 – cont.	Ch. 8.5-8.8
10-Nov, Mon	Structured Query Language 4	Ch. 9	Phase I of your projects is due today!!!
12-Nov, Wed	File Organization	Ch. 13
14-Nov, Fri	Indexing Files and B-trees	Ch. 14-14.2	SQL Homework is due at the beginning of the class. Last 2 examples in larger format are here. There are also in your textbook.
17-Nov, Mon	Indexing Files and B-trees	Ch. 14-14.2
19-Nov, Wed	Indexing Files and B-trees	Ch. 14-14.2
21-Nov, Fri	More on B+Trees	Ch. 14.3-14.5
24-Nov, Mon	Query Processing	Ch. 15	Phase II of your projects is due today!!!
26-Nov, Wed	Query Processing – cont.	Ch. 15
28-Nov, Fri	Thanksgiving Day holiday (no classes)
1- Dec, Mon	Query Processing - practice	Ch. 15	Phase III of your projects is due today!!!
3- Dec, Wed	Exam 3 (15% of final grade)		The exact date has been decided!
5- Dec, Fri	Review for Final Exam	ERD in larger format
8-Dec, Mon	Project Demos		Rules for your presentations, Complete projects are due today!!!
10-Dec, Wed	Project Demos
12-Dec, Fri	Project Demos
15-Dec, Mon	4-5:50 PM - FINAL EXAM (20%) in EPS 108