CS360 Database Management

for S2QQ 2005

Printer Friendly

Mission Statement: The mission of Park University, an entrepreneurial institution of learning, is to provide access to academic excellence, which will prepare learners to think critically, communicate effectively and engage in lifelong learning while serving a global community.

Vision Statement: Park University will be a renowned international leader in providing innovative educational opportunities for learners within the global society.

CourseCS 360 Database Management HI
FacultyGrotzky, John
TitleAdjunct Faculty
Degrees/CertificatesMasters of Business Administration
Bachelors of Science in Computer Science
Bachelors of Science in Electrical Engineering
Office LocationHill AFB Campus
Office HoursEmail and phone.
Semester DatesMar 14 - May 8, 2005
Class Days--T-R--
Class Time4:30 - 7:15 PM
PerquisitesCS140 (Suggested)
Credit Hours3

Post, Database Management Systems, 3rd Edition, McGraw-Hill, 2005, ISBN 007-297312-9.

Textbooks can be purchased though the MBS bookstore

Course Description:
This course provides an overview of database system concepts.  The course deals with file organization methods, database models, data integrity and security, and database administration issues.  The student will be introduced to application program development in a database environment with emphasis on setting, modifying, and querying a database.  Pre-requisite: CS219. 3:0:3

Educational Philosophy:
"The aim of education should be to teach us rather how to think, than what to think - rather to improve our minds, so as to enable us to think for ourselves, than to load the memory with thoughts of other men."
-Bill Beattie

Learning Concepts

It is a new world out there!  The opportunities to learn are greater than ever.  The internet and computer technology are breaking down learning barriers and providing an opportunity for everyone to become educated.  It is my hope that students will see the incredible opportunities that are available to become educated.  Not filled with memorized facts, but using their minds to engage in critical thinking and to form their own educated opinions.

I believe the access to information will light a fire in students and make them realize the unlimited potential they have to succeed.  This potential for success will produce one of the important factors needed in becoming successful in whatever you pursue – motivation!  A motivated student will put their best effort into their academic, professional and personal pursuits.

Teaching Concepts

My primary role as a teacher is to provide a superior learning experience for the students.  I believe that a healthy relationship between the teacher and students as “essential to successful teaching.”  I believe it is important for the students to develop a relationship with other students.  In a face-to-face classroom, I introduce myself and provide some basic information to the students.  This information usually includes a name, current employer, hometown, and hobbies.  This begins the process of building a sense of community in the classroom.  This sense of community will make the students feel like they belong and foster the learning process.
The course material is presented in an organized manner with specific goals outlined.  I will create a learning atmosphere using a variety of teaching methods.  The methods will include videos, computer and internet resources, group or individual projects and teacher led discussions.

I want students to leave my classes feeling like they have learned what they should have learned.  I also want them to come away with an understanding that if they apply themselves to the task at hand, they will succeed.
Goals for Students

I have 3 primary goals for students.  First, I want them to think critically, both in my class as well as in all other aspects of their lives.  Secondly, I want them to understand the opportunities that exist in this information oriented society and to spark a desire to pursue these opportunities.  Third, and most important, I want them to enjoy the learning experience and to continue it for the rest of their lives.

Learning Outcomes:
Upon completion of this course, the student should be able to:

1.  Describe a relational database and object-oriented database.

2.  Describe components of a database management system and the techniques used to store and access data within the DBMS.

3.  Utilize modeling software to build a database design.

4.  Describe normalization and perform normalization of a database model.

5.  Understand the basic fundamentals of Structured Query Language (SQL).

6.  Use SQL to create the tables within a database and queries for updating tables.

7.  Utilize SQL to build queries to extract data from multiple tables based on selection criteria.

8.  Describe the duties of the database administrator.

9.  Describe the creation and use of metadata and data dictionaries.

10.  Understand issues of implementing an enterprise database or other DBMS solution such as concurrency, efficiency, management of and security.

11.  Understand the role and issues surrounding the management of data such as efficiency, privacy, security, ethical responsibility, and strategic advantage.

12.  Describe and understand the role of web-enabling databases.

Course Assessment:
I give a weekly quiz during the first 10-minutes of class on Tuesday.  Quizzes will be on the assigned review questions.  There will be assignments on each chapter.  The assignments will include a combination of review questions and exercises.  The assignments will be due the first of class each Tuesday.  There will be a midterm and final exam.  An individual project will be assigned and due at the end of the term.

Quizzes on Review Questions 10%
Assignments   20%
Project 20%
Midterm Exam 20%
Final Exam 30%

Late Submission of Course Materials:
No late work will be accepted, except for extenuating circumstances.

Course Topic/Dates/Assignments:
Date      Chapter Topic
Mar 15 1 Welcome/Introduction
                       Chapter 1 – Introduction

Mar 17 1 Chapter 1 – Introduction(continued)


Mar 22 2 Quiz 1
Assignment 1 Due
Chapter 2 – Database Design

Mar 24 2 Chapter 2 – Database Design (cont.)


Mar 29 3 Quiz 2
Assignment 2 Due
                       Chapter 3 – Data Normalization

Mar 31 3 Chapter 3 – Data Norm. (cont.)


Apr 5 4 Quiz 3
                       Assignment 3 Due
Chapter 4 – Data Queries



Apr 12 4 Chapter 4 – Data Queries (cont.)

Apr 14 5 Quiz 4
                       Assignment 4 Due
                       Chapter 5 – Adv. Queries


Apr 19 5 Chapter 5 – Adv. Qeries (cont.)

Apr 21 6 Quiz 5
                       Assignment 5 Due
                       Chapter 6 – Forms, Rprts and Apps


Apr 26 6 Ch 6 – Frms, Rprts and Apps (cont.)

Apr 28 - Quiz 6
                       Assignment 6 Due
                       Database Development Wrap-up
Project Presentations


May 3 - Project Presentations


Academic Honesty:
Academic integrity is the foundation of the academic community. Because each student has the primary responsibility for being academically honest, students are advised to read and understand all sections of this policy relating to standards of conduct and academic life.  
Park University 2004-2005 Undergraduate Catalog
Page 101

Plagiarism involves the use of quotations without quotation marks, the use of quotations without indication of the source, the use of another's idea without acknowledging the source, the submission of a paper, laboratory report, project, or class assignment (any portion of such) prepared by another person, or incorrect paraphrasing. <a href="http://www.park.edu/catalog">
Park University 2004-2005 Undergraduate Catalog</a> Page 101

Attendance Policy:
Instructors are required to maintain attendance records and to report absences via the online attendance reporting system.

  1. The instructor may excuse absences for valid reasons, but missed work must be made up within the semester/term of enrollment.
  2. Work missed through unexcused absences must also be made up within the semester/term of enrollment, but unexcused absences may carry further penalties.
  3. In the event of two consecutive weeks of unexcused absences in a semester/term of enrollment, the student will be administratively withdrawn, resulting in a grade of "WH".
  4. A "Contract for Incomplete" will not be issued to a student who has unexcused or excessive absences recorded for a course.
  5. Students receiving Military Tuition Assistance or Veterans Administration educational benefits must not exceed three unexcused absences in the semester/term of enrollment. Excessive absences will be reported to the appropriate agency and may result in a monetary penalty to the student.
  6. Report of a "F" grade (attendance or academic) resulting from excessive absence for those students who are receiving financial assistance from agencies not mentioned in item 5 above will be reported to the appropriate agency.

Park University 2004-2005 Undergraduate Catalog Page 100

Disability Guidelines:

Park University is committed to meeting the needs of all students that meet the criteria for special assistance. These guidelines are designed to supply directions to students concerning the information necessary to accomplish this goal. It is Park University's policy to comply fully with federal and state law, including Section 504 of the Rehabilitation Act of 1973 and the Americans with Disabilities Act of 1990, regarding students with disabilities. In the case of any inconsistency between these guidelines and federal and/or state law, the provisions of the law will apply. Park University is committed to meeting the needs of all learners that meet the criteria for special assistance. These guidelines are designed to supply directions to learners concerning the information necessary to accomplish this goal. It is Park University's policy to comply fully with federal and state law, including Section 504 of the Rehabilitation Act of 1973 and the American with Disabilities Act of 1990, regarding learners with disabilities and, to the extent of any inconsistency between these guidelines and federal and/or state law, the provisions of the law will apply. Additional information concerning Park University's policies and procedures related to disability can be found on the Park University web page:

This material is copyright and can not be reused without author permission.