Regis University Logo, Learners Becoming Leaders in the Jesuit Tradition CS442 - Database Programming

04/10/07

 

 

General Information

 

Facilitator: Wayne Cook

  Home:  (970)229-9282         Cell:  (970)690-9976

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

Term:  Spring 8W2 2006

Meeting Times:  Starting Tuesday, 7 March 2006 - 6:00 PM until 10:00 PM

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.

Class Note

This class is strictly programming.  It is based on a outline developed within Regis and has a very structured approach to learning SQL programming.  For Spring 2007, the database used has switched from PostgreSQL to MySQL.  You need to load MySQL on your system instead of PostgreSQL, even though the latter comes on the disk from Regis.

Course Description

CS442. DATABASE PROGRAMMING (3). Introduces the ANSI standard structured query language (SQL). Includes various extensions to the language, design and implementation of a relational database, data manipulation, joining tables, creating and using views, use subqueries, data security and integrity.

Course Prerequisites

CS445 Database Management

Course Materials

Required Text: Kofler, Michael. (2005). The definitive guide to MySQL 5 (3rd edition). Berkeley, CA: Apress.  ISBN: 1590595351.

Required Software:  Free Download: MySQL - download the latest version MySQL which is found at http://www.mysql.com/products/

Class Schedule

Please read the assigned chapters  and complete each homework assignment before the scheduled class.  We will cover key elements of each assignment and any areas on which you might have questions.  However, we will not be able to cover all of the topics presented in the textbooks, so please read them well so that you may have a better understanding of the material.  Historically, there has been a significant amount of work associated with this class, so please plan to spend time out of class preparing for each week.

Please also see the General Notes at the bottom of this web page.

Session

Topics covered and classroom activities

Assigned Reading

Assignments Due

One

LT #1: Database Design Review

LT #3: Database Installation and Configuration

Chapters 1, 2, 8

 

First Night assignment

Two

LT #2: Structured Query Language

LT #4: Development Environment and Tools

Chapters 3, 9, 10

Lab #1

Three

LT #9: Stored Procedures and Triggers

Chapter 4, 13

Lab #2

Four

LT #6: Error and Exception Handling

Chapter 5, 21

Lab #3

Five

LT #5Built-in Functions

LT#7:  Functions

Chapter 10

Lab #4

Six

LT #8:  Database Administration

Chapters 11, 14

Lab #5

Seven

LT #10Advanced Features

Chapters 15-20

Lab #6

Eight

Final Presentation

Chapter 7

Final Exam

     

General Notes

All assignments should build on each other.  If it is not clear how this should occur, please ask questions.  If there are additional documents that you feel you need to provide to complete your design, please add them.  Some additional documents will be discussed during the course of this class.  Good luck with all of your assignments.

Questions and Answers

First check the class syllabus, then check for similar questions from the class in my Q and A file.

Homework Status

You can check your homework here.

Regis University Information

Academic Dishonesty 

Regis University is committed to intellectual integrity in its academic pursuits.  Sanctions may, therefore, be imposed by the School for Professional Studies Undergraduate faculty, departments, or programs for cheating (defined as using inappropriate sources of information on a test) or plagiarism (defined as presenting as one’s own, the ideas, words, or products of another).  Such sanctions may include a failing grade on the assignment, failure of the course, or expulsion of the student from the course or the department.

 Attendance/Participation 

 The expectation is for students to attend all class sessions.  Because of the accelerated nature of the course work in the School for Professional Studies, missing any class may have a negative impact on the student’s learning and course performance.  Any student who misses the first class must contact the facilitator/instructor or the Faculty and Curriculum Department either prior to the first class session or as close to the first class session as possible.  If a student fails to do so, he/she will automatically be dropped from the course.  A student who has not attended the first class session may be admitted to the course only with facilitator/instructor permission.

 Make up work may be required if the student misses a class.  This work is arranged, in advance if possible, between the facilitator/instructor and the student.  The student is responsible for contacting the facilitator for the additional assignments(s).

Incomplete Grade 

 A grade of Incomplete or ‘I” denotes that the required work for the course is incomplete due to unforeseen circumstances.  Unforeseen circumstances mean, for example, that an accident, an illness, a death, or a major life transition has occurred.  This grade is awarded at the discretion of the instructor and is submitted with an alternate grade of “I/F.”

 A student must submit a written request to the instructor asking that an incomplete grade be assigned prior to the end of the term in which the course is taken.  The course instructor will determine the length of time for course completion, and the remaining requirements to complete the course; however the maximum time for completion is the end of the following semester.  Faculty will notify students in writing of the approval/denial of their request and provide instructions and guidelines required to resolve the incomplete grade.  If the course work is not completed by the end of the next applicable semester and a grade change form submitted by the instructor, the incomplete grade reverts to the alternate grade assigned by the instructor and is calculated in the grade point average.

 Disability Guidelines

 Regis University is committed to ensuring equal access to programming for qualified students with disabilities.  Students with documented disabilities who are seeking accommodations must work through the Office of Disability Services (ODS).

 Eligibility

To be eligible for services, qualified students with documented disabilities must register with the ODS.  Documentation must be current in order to receive services.  The ODS is located in the Life Directions Center, Room 118; 303-458-4941; disability@regis.edu. Appropriate accommodations are based upon documentation.  Accommodations are granted on a case-by-case basis depending upon the disability and the documentation.

 Students may disclose and request accommodations at any time during the term; however, it is suggested that students disclose at the beginning of their academic career since accommodations are not retroactive.

 Five and 8-week courses are fast paced and reading intensive.  Please be aware that incomplete grades are seldom granted; these courses are expected to be completed during the term.  If you have concerns about your disability and the fast pace of these types of courses, please talk to your program advisor and/or with a member of the ODS.

 Diversity

 “Diversity” often is a term tossed around with little thought to its meaning. But at Regis University, the term diversity is at the core of our faith-inspired commitment to build an inclusive community that values the dignity and contributions of all our members.

 At Regis, our differences should thrive in a learning environment characterized by the Jesuit traditions of mutual respect and the pursuit of justice. Respecting our human differences, whether they are physical or philosophical, is what diversity is all about. It is not necessary that we all believe the same thing, but we all must respect others’ beliefs and opinions. Within Jesuit tradition, respect for self and others is critical. A learning community that embraces a diversity of thoughts and ideas benefits all of its members. The discovery and discussion of different viewpoints is what makes a university unique.

 Incidents of intolerance and disrespect on campus are thoroughly investigated and individuals who behave disrespectfully will be held responsible for their actions according to University policies and procedures.

 At Regis University, policies and practice are based on our Jesuit mission of maintaining a campus climate in which the civil rights of every individual are recognized and respected. Accordingly, acts of disrespect and discrimination, no matter how subtle, are not acceptable and will not be tolerated.

 We are actively pursuing measures to increase diversity on our campus in all areas of human difference, not because it is the “in” thing to do, but because it is the right thing to do. 

 It is imperative that we continue to make Regis University a safe and welcoming community of which we may all be proud to be a part. To contact the Diversity office call (303) 458-5304 or e-mail: diverse@regis.edu

 Tutoring Information

 The SPS Undergraduate Program realizes that occasionally students need additional assistance with course content.   Tutorial assistance is available to students through Smarthinking, writing

This site was last updated 03/13/07