Class Outline for Database Systems (CS
435) in Fall 2009
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 the 2nd part of this course: http://www.fabforce.net/ - check out
DBDesigner 4 or MySQL Workbench 5.0…
|
Date
|
Lecture Topics |
Assigned Readings |
Other Assignments & Comments |
|
31-Aug, Mon |
Ch.1.1-6 |
Refer to your handout+ Fill out: Let's meet, Read:
My General Class
Guidelines |
|
|
2-Sep, Wed |
Ch. 2.1-3, 2.5-7. |
Refer to your handout |
|
|
4-Sep, Fri |
Ch. 2.4 |
Study
handout in detail! |
|
|
7-Sep, Mon |
Labor
Day (no classes) |
Party hard! :) |
|
|
9-Sep, Wed |
Ch. 3.1-4 |
Read Handouts. Study examples in the
textbook. |
|
|
11-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!) |
|
14-Sep, Mon |
Ch. 3.5-9 |
||
|
16-Sep, Wed |
Review on ER + Practice: My
Music Database Design |
|
There
can be a short Quiz on Data Modeling (Ch. 3) today! |
|
18-Sep, Fri |
Intro
to EER Model [HOMEWORK UPDATED] |
Ch. 4 |
Homework is due today!!! |
|
21-Sep, Mon |
Ch. 4 |
||
|
23-Sep, Wed |
Ch. 5 |
|
|
|
25-Sep, Fri |
Relational
Database Model - cont. + Intro To Relational
Algebra |
Ch.
6.1-3 |
Homework is due today!!! |
|
28-Sep, Mon |
Intro To Relational Algebra - cont. +
Review of your homework |
Ch.
6.1-3 |
|
|
30-Sep, Wed |
Ch. 6.3-4 |
|
|
|
2-Oct, Fri |
Relational Algebra and Calculus - cont. |
Ch. 6.5-7 |
|
|
5-Oct, Mon |
|
Here
are my solutions. |
|
|
7-Oct, Wed |
Ch. 7.1-2 |
Here
are some exercises
for practice. |
|
|
9-Oct, Fri |
Ch. 7.2-3 |
|
|
|
12-Oct, Mon |
Ch. 10.1-2 |
|
|
|
14-Oct, Wed |
Functional Dependencies - cont. |
|
|
|
16-Oct, Fri |
Ch. 10.3-6, 11-Intr |
Here
are my solutions. |
|
|
19-Oct, Mon |
Normalization - cont. |
There can be a short Quiz on
Functional Dependencies today! |
|
|
21-Oct, Wed |
|
|
|
|
23-Oct, Fri |
|||
|
26-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. |
|
28-Oct, Wed |
Ch. 8-8.2 |
||
|
30-Oct, Fri |
Ch. 8.3-8.4 |
Pre-proposals for your projects are due today!!! |
|
|
2-Nov, Mon |
Structured Query
Language 2 – cont. |
Ch. 8.3-8.4 |
SQL
Homework is here. SQL script needed for
this homework is here. |
|
4-Nov, Wed |
Ch. 8.5-8.8 |
||
|
6-Nov, Fri |
Exam 2
Review |
Ch. 8.5-8.8 |
|
|
9-Nov, Mon |
Ch. 9 |
Phase I of your projects is due today!!! |
|
|
11-Nov, Wed |
Veteran’s
Day (no classes) |
Enjoy
your day off! |
|
|
13-Nov, Fri |
Ch. 13 , 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. |
|
|
16-Nov, Mon |
Ch. 14-14.2 |
|
|
|
18-Nov, Wed |
Ch. 14-14.2 |
The
same B+Tree, but bigger! |
|
|
20-Nov, Fri |
Ch.
14.3-14.5 |
Do
you want to practice insertion to B+Tree? Here is another example. |
|
|
23-Nov, Mon |
Ch. 15 |
Phase II of your projects is due today!!! |
|
|
25-Nov, Wed |
Thanksgiving Day holiday (no classes) |
Give thanks!!!!!!!!! |
|
|
27-Nov, Fri |
Thanksgiving Day holiday (no classes) |
Give thanks!!!!!!!!! |
|
|
30-Nov, Mon |
Ch. 15 |
Phase III of your projects is due today!!! |
|
|
2-Dec, Wed |
Exam 3 (15% of final grade) |
|
The
exact date has been decided! |
|
4-Dec, Fri |
Rules for your presentations, Complete projects are due today!!! |
||
|
7-Dec, Mon |
Project Demos |
|
|
|
9-Dec, Wed |
Project Demos |
|
|
|
11-Dec, Fri |
Project Demos |
|
|
|
15-Dec, Tue |
4-5:50 PM - FINAL EXAM (20%) in EPS
108 |
|
|