CS125DB Syllabus


CS 125DB – Database Management

Fall 2009


Instructor:  Cyndy Patterson

Office Hours: B24: M, W: 4 – 5, T, R: 1:30 – 3,  or by appointment

Phone: RVC - 245-7532

E-mail:  either cpatterson@roguecc.edu 

Web Site:  http://learn.rogue.cc/ComputerScience/cpatterson/home.htm




Course Prerequisites


CS101, CS120, or previous computer experience and consent of instructor; and MTH65.


Course Expectations and Goals


ü  Have a working knowledge of database terminology;

ü  Know how to use database software as a business tool;

ü  Learn the structure of a relational database;

ü  Learn to use the database in creating business reports.


Assignments, Labs and Exams


You are responsible for the material covered in the class as well as getting the lab assignments completed on time.  I expect that you will read the textbook material and work through the Hands On Exercises to familiarize yourself with the subject matter. 


You can obtain the data files you will need for the class from either the Q:CS125DB folder on the campus drives, or from the following web site:  www.prenhall.com/exploring . 


There will be a lab assignment per chapter.  You will usually be given at least a week to get them turned in. Late submissions will receive a significant penalty.  There will also be occasional in-class assignments.  Quizzes will be given at the end of every two chapters, or following a major topic.  A missed test or assignment is a score of zero(0).


It is expected that you will complete each assignment.  It is my opinion that “group computing” is an effective learning experience for only selected members of the group—the ones who do the work.  Do not turn in someone else’s work as your own, or allow someone to copy your work. 


There will be a final project that you will be given about mid-term.  This will be a comprehensive project that should demonstrate your understanding of the course material.  I strongly urge you not to wait until the end of the term to start on this.  You will be using knowledge gained throughout the quarter on this. 


There will be a comprehensive final exam given the last week of the term.

Grading Criteria and Scale


Assignments and quizzes will be graded on an objective basis; the scoring of the final project will have a subjective component based on my observations of your working methods, and the initiative and independence you display in completing the project. 


Letter grades will be assigned to the number of points accumulated on assignments, quizzes and the final exam. No incomplete can be given, except in extraordinary circumstances.  Pass/Fail grades and audits are acceptable methods for taking this class. A tentative list of possible points is as follows:


Points per task                                                                   Grading Scale


Lab assignments          10 - 15 points each                        90% - 100%                A

In-class assignments      5 points each                               80 – 89                        B

Final project                  50 points                                        70 – 79                        C

Quizzes                          20 - 25 points each                        60 – 69                        D

Final Exam                    50 - 75 points                                   0 – 59                        F



You are assured that the grade you earn from this class will minimally be the letter grade that corresponds to your ending point total.  However, I reserve the right and responsibility to assign a higher letter grade when circumstances justify so doing.


Points will be recorded with an electronic spreadsheet program. Although I will attempt to be accurate in recording point scores, mistakes can happen. For your own protection, audit the portion of the listing that applies to you. Access to your grades will be made available from the web site as well. The procedure for accessing this document will be discussed in class.  For your own protection, please provide me with a 4 digit code to use in identifying your records.


Required Text and Materials


The text for this class is: Exploring Access 2007 Comprehensive by Grauer and Barber.  You will be responsible for keeping backups of your work.  I will ask for your assignments to be turned in on diskette or CD with the accompanying printouts.  Please do not e-mail them to me!  Obtain a few large envelopes to put all the materials for an assignment in to hand in. An alternate way to turn in assignments will be provided through Angel, our online course delivery system.




Any student who feels that she or he may need an academic accommodation for any disability, such as vision, hearing, orthopedic, learning disabilities, psychological or other medical conditions, should make an appointment with the Support Services Office, located in G Building at the Riverside Campus.

The Computer Science Integrity Policy


The Computer Science department seeks to promote professional, academic, and personal honesty. Therefore, any student found cheating, plagiarizing, stealing examinations or course materials, inappropriately accessing and/or using another individual's work, or deliberately misrepresenting someone else's work for their own will be temporarily removed and failed from the class where the infraction takes place. Additionally, the Computer Science department will recommend that the individual be removed from the college.


Furlough Days


Due to Oregon’s financial situation, college faculty and staff agreed to six furlough days in exchange for a reduction of pay. This means classes will not be held on Wednesdays and Thursdays the last week of fall, winter and spring terms (December 9-10, March 17-18 and June 9-10).  Please see your faculty advisor prior to these closure days. Other college services will be open those days.




Pandemic H1N1 (referred to as “swine” flu) is a concern for all of us. As with any health concern, it is imperative that you make the best decisions regarding your own health. RCC encourages you to take care of yourself and to consider the health of others around you. Students are encouraged to stay home if they feel sick, and to contact their instructor immediately to make arrangements for missed work.