CS445 Database Management

		CS445 - Database Management

01/16/07

Facilitator: Wayne Cook

H: (970)229-9282 C: (970)690-9976

E-mail: wcook@regis.edu or ww_cook@msn.com

Grading:

Grade	Range	Grade	Range
A	93%-100%	D+	67%-69%
A-	90%-92 %	D	63%-66%
B+	87%-89 %	D-	60%-62%
C+	77%-79%	F	0%-59%
C	73%-76%
C-	70%-72%

5% lost for every week a homework is late (unless other arrangements are made), no homework can be turned in past last night of class.

Which Database to Use?

Originally this course was taught using Access and the Adamski/Finnegan Tutorial book. The current recommended SQL Database is MySQL, which is a free Database available over the web. Since the programming course (CS455) uses PostgreSQL instead of MySQL, I will accept assignments using PostgreSQL instead of MySQL. Tutorials for MySQL are found on the web.

I will be adding references to various tutorials for MySQL as I determine which ones are the best. There are three scripting languages that can be used with MySQL. I will be looking for the best tutorials for PHP, Perl, and Python. Look up tutorials for these three ways of accessing MySQL and decide which one serves you best. For now, PHP seems to be the most common, but there are arguments for both Perl and Python.

Extra credit will be given for pointers to good tutorials on using SQL. Also, a good portion of this class is Analyzing a person's or group's need for a database. If you want some more information about good documents for design, please see my Q&A information for the CS432 class.

Installation of MySQL:

Please download MySQL from: http://dev.mysql.com/doc/refman/5.0/en/installing.html

Please refer to the MySQL reference manual at: http://dev.mysql.com/doc/refman/5.0/en/index.html

The assignments will be based off of the deliverables for the Final Assingment.

Class Outline:

Week	Date	Assignment
1	01/09/07	Rob/Coronel – *Database Systems: Chapters 1-3 MySQL: Go through the tutorial: MySQL Basics -- A Helpful MySQL Tutorial*
2	01/16/07	R/C: Chapters 3 & 4 MySQL: Tutorial: A Look at the MySQL CSV Storage Engine H/W: Bring in three possible projects with a brief description of each. C/W: Time will be available in class to select the database project and review the Final Assingment. Also, review how to create and ask questions.
3	01/23/07	R/C Chapters 5 & 6 H/W: Database project overview and preliminary schedule due – 1 to 2 people – one page description (10 points) C/W: Review Questions, check progress in the gathering of information process.
4	01/30/07	R/C Chapters 7 & 8 H/W: Initial ERD's, Data Dictionary, and Project Status Summary (10 points)
5	02/06/07	R/C Chapters 9 & 10 H/W Basic design for Project (10 points) H/W: Project Status Summary (10 points)
6	02/13/07	R/C Chapter 11 H/W: Project Status Summary (10 points)
7	02/20/07	C/W Present Project Status (20 points) Project Work - in class
8	02/27/07	C/W: Presentation of Projects (30 points) H/W: Papers & Sample DBs (this may be just the design work and the actual DB may be optional, this will be determined by the second week of the course) due (60 points)

This site was last updated 01/16/07