Syllabus Entrance
Printer Friendly
Email Syllabus

CS 360 Database Management
Tonsmann, Guillermo


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.

Course

CS 360 Database Management

Semester

S1A 2009 BE

Faculty

Tonsmann, Guillermo

Title

Associate Professor of Computer Science

Degrees/Certificates

Ph.D. Computer Science, Louisiana State University (Baton Rouge, Louisiana)
Honors B.S. Computer Science, University of South Africa (Pretoria, South Africa)
M.Eng. in Chemical Engineering, Potchefstroom University (Potchefstroom, South Africa)

Office Location

Austin Campus - Room 109

Office Hours

Mondays and Wednesdays from 3:00pm to 5:00pm or at other times by appointment

Daytime Phone

(512) 385-7275 ext 209

E-Mail

tonsmann@park.edu

Web Page

http://kidd.park.edu/tonsmann

Semester Dates

Monday, January 12, 2009 through Sunday, March 08, 2009

Class Days

------S

Class Time

9:00 - 2:10 PM

Prerequisites

CS 219

Credit Hours

3


Textbook:

Textbook:
Hoffer, Modern Database Management, 8th Edition,
Prentice Hall, 2006, ISBN 978-0132212113.

Textbooks can be purchased through the MBS bookstore

Additional Resources:

McAfee Memorial Library - Online information, links, electronic databases and the Online catalog. Contact the library for further assistance via email or at 800-270-4347.
Career Counseling - The Career Development Center (CDC) provides services for all stages of career development.  The mission of the CDC is to provide the career planning tools to ensure a lifetime of career success.
Park Helpdesk - If you have forgotten your OPEN ID or Password, or need assistance with your PirateMail account, please email helpdesk@park.edu or call 800-927-3024
Resources for Current Students - A great place to look for all kinds of information http://www.park.edu/Current/.


Course Description:
CS360 Database Management: 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 up, modifying, and querying a database. Prerequisite: CS219. 3:0:3

Educational Philosophy:
Students will be exposed to lectures, readings, and discussion threads to explore concepts and issues in modern database management. Assignments will give the opportunity to put in practice these concepts.

Learning Outcomes:
  Core Learning Outcomes

  1. Analyze the difference between Data and Database management (1, 2, 3)
  2. Explain the duties of the data and database administrator. (41, 42, 45)
  3. Describe the creation and use of metadata and data dictionaries. (4, 6, 26, 27, 37, 38, 47)
  4. Identify the organizational perspective of managing data such as efficiency, privacy, security, ethical responsibility, and strategic advantage. (5, 7, 8, 9, 10, 11, 12, 13, 14, 15, 43, 44, 46)
  5. Compare a Relational Database and Object Orientated Database. (16, 23, 24)
  6. Analyze components of a Database Management System and the techniques used to store and access data within DBMS. (17, 18, 19, 20, 21, 22, 25, 36, 39, 40, 49)
  7. Describe a Data Warehouse including possible designs, use and terminology. (48, 49, 50)
  8. Explain and apply the fundamentals of Structured Query Language (SQL). (28, 29, 30, 31, 32, 33, 34, 35)


Core Assessment:
The core assessment for this course is a final exam which counts for 20% of the grade. Questions on the final exam will be developed to test at least eight of the eight course core objectives. Correspondence between core learning outcomes and the sample final exam artifact are as follows:

Link to Class Rubric

Class Assessment:
Students are expected to:
A. Complete the reading assignments for the week as indicated in the Class Schedule.
B. Attend and participate classes actively.
C. Participate actively in online discussion threads. Students will be required to post their answers to selected questions and to post at least one comment on the answers of their peers. These questions will be based on the reading assignments for the week. Each posting should be of at least 100-words-length.
D. Complete all homework/assignments when scheduled. There will be at least 4 assignments in the semester.
E. Complete the final exam when scheduled.

Grading:
Grading:
Online participation                                            20%
Homework/Assignments                                    50%
Final Exam                                                         30%

Grade Scale
A = 100 –90
B =  89 –80
C =  79 –70
D =  69 –60
F = below 60

Late Submission of Course Materials:
Homework is due at the beginning of class on the stated due-date. 
Late homework may be accepted, if
 (1) such arrangement is previously established with the instructor and
 (2) evidence of progress is demonstrated on the due date.
Late assignments may carry penalties at the instructor discretion.

Given the temporal nature of discussion threads, all postings to these threads must be done in their appropriate week. No points will be granted for late (or by the same token, early) posts. There will be no "make-up" for postings.

Classroom Rules of Conduct:
LAST DAY TO DROP:  Monday, January 19, 2009
LAST DAY TO WITHDRAW:  Sunday, February 15, 2009

INCOMPLETE GRADE:  As a rule, incomplete grades will not be given.  Exceptions to the rule do exist, however, like a prolonged hospitalization and/or traumatic death in the family. In these cases, the student may be allowed to petition for an incomplete.  The instructor retains the right to veto any such petition, or grant an incomplete in other unforeseen circumstances.

WITHDRAW:  The enrollment status of the student in this course is solely the responsibility of the student. If a student wishes to withdraw from this course, s/he must file the appropriate paperwork with the registrar before the appropriate deadlines. Every student is considered enrolled unless s/he is officially withdrawn.

Other Rules
1. Keep a memory stick, floppy disk and/or CDRW handy at all classes for storage of course material.
2. Students should disconnect or set to silent any cellular phones or beeping devices during class sessions.
3. Students should refrain from disruptive behavior during class sessions.
4. Students must check their account on www.parkonline.org and their Park email regularly. Class announcements and class materials will be distributed using one of both services. Discussion threads will be held through www.parkonline.org.

Course Topic/Dates/Assignments:

Class schedule and activities may change at the instructor's discretion to pace students' learning.
 
 

Session

Class Activities

Homework Given

Homework Due Date

Required Reading from textbook for the week

Online Activity for the Week

Saturday Jan. 17, 2009

Introduction to the course.
Chapter 1. The Database Environment.
Chapter 2. The Database development Process.

Chapters 1 & 2.

Saturday Jan 24, 2009

Chapter 3. Modeling Data in the Organization.
Chapter 4. The Enhanced E-R Model and Business Rules

Assignment 1 Given

Chapters 3 & 4

Post answers to questions on Week 2’s discussion thread.
Post comments on the answers of your peers.

Saturday Jan. 31, 2009

Chapter 5. Logical Database Design and the Relational Model

Assignment 2 Given

Chapter 5

Post answers to questions on Week 3’s discussion thread.
Post comments on the answers of your peers.

Saturday Feb. 07, 2009

Chapter 6. Physical Database Design and Performance.
Chapter 7. Introduction to SQL.

Assignment 3 Given

Assignment 1 Due Date

Chapters 6 & 7

Post answers to questions on Week 4’s discussion thread.
Post comments on the answers of your peers.

Saturday Feb. 14, 2009

Chapter 8. Advanced SQL.
Chapter 9: The Client/Server Database Environment.

Assignment 2 Due Date

Chapters 8 & 9

Post answers to questions on Week 5’s discussion thread.
Post comments on the answers of your peers.

Saturday Feb. 21, 2009

Chapter 10. The Internet Database Environment.
Chapter 13: Overview: Distributed Databases
Chapter 11. Data Warehousing.

Assignment 4 Given

Assignment 3 Due Date

Chapters 10, 11 & 13

Post answers to questions on Week 6’s discussion thread.
Post comments on the answers of your peers.

Saturday Feb. 28, 2009

Chapter 12. Data and Database Administration.
Chapter 14. Overview: Object Oriented Data Modeling.

Chapters 12 & 14

Post answers to questions on Week 7’s discussion thread.
Post comments on the answers of your peers.

Saturday March 07, 2009

Final Exam (Comprehensive).

Assignment 4 Due Date

Post answers to questions on Week 8’s discussion thread.
Post comments on the answers of your peers.

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 2008-2009 Undergraduate Catalog Page 87

Plagiarism:
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. Park University 2008-2009 Undergraduate Catalog Page 87

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 "F".
  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 2008-2009 Undergraduate Catalog Page 89-90

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. Additional information concerning Park University's policies and procedures related to disability can be found on the Park University web page: http://www.park.edu/disability .



Rubric

CompetencyExceeds Expectation (3)Meets Expectation (2)Does Not Meet Expectation (1)No Evidence (0)
Evaluation                                                                                                                                                                                                                                                 
Outcomes
3                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
The artifact demonstrates the student ability to judge relative value of information based on prior knowledge. Evaluation is demonstrated by correctly answering 3 out of 3 questions regarding: (a) relational data base characteristics (b) object oriented data base characteristics (c) comparison of relation and object oriented databases. The artifact demonstrates the student ability to judge relative value of information based on prior knowledge. Evaluation is demonstrated by correctly answering 2 out of 3 questions regarding: (a) relational data base characteristics (b) object oriented data base characteristics (c) comparison of relation and object oriented databases. The artifact demonstrates the student ability to judge relative value of information based on prior knowledge. Evaluation is demonstrated by correctly answering 1 out of 3 questions regarding: (a) relational data base characteristics (b) object oriented data base characteristics (c) comparison of relation and object oriented databases. The artifact demonstrates the student ability to judge relative value of information based on prior knowledge. Evaluation is not demonstrated when less than 1 out of 3 questions are correctly answering regarding: (a) relational data base characteristics (b) object oriented data base characteristics (c) comparison of relation and object oriented databases. 
Synthesis                                                                                                                                                                                                                                                  
Outcomes
3,7                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
The artifact demonstrates the student ability to creatively apply prior knowledge and skills to produce an original narrative. Synthesis is demonstrated by correctly answering 10 out of 10 questions regarding: (a) creation and use of meta data and data dictionaries (b) data warehouse designs, use, and terminology The artifact demonstrates the student ability to creatively apply prior knowledge and skills to produce an original narrative. Synthesis is demonstrated by correctly answering 7 out of 10 questions regarding: (a) creation and use of meta data and data dictionaries (b) data warehouse designs, use, and terminology The artifact demonstrates the student ability to creatively apply prior knowledge and skills to produce an original narrative. Synthesis is demonstrated by correctly answering 5 out of 10 questions regarding: (a) creation and use of meta data and data dictionaries (b) data warehouse designs, use, and terminology The artifact demonstrates the student ability to creatively apply prior knowledge and skills to produce an original narrative. Synthesis is not demonstrated when less than 5 out of 10 questions are correctly answered regarding: (a) creation and use of meta data and data dictionaries (b) data warehouse designs, use, and terminology 
Analysis                                                                                                                                                                                                                                                   
Outcomes
1,6                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
The artifact demonstrates the student ability to differentiate information in an organizational structure. Analysis is demonstrated by correctly answering 14 out of 14 questions of the type: (a) components of a Database Management System or DBMS (b) techniques used ot store and access data within a DBMS (c) data management and data base management The artifact demonstrates the student ability to differentiate information in an organizational structure. Analysis is demonstrated by correctly answering 10 out of 14 questions of the type: (a) components of a Database Management System or DBMS (b) techniques used ot store and access data within a DBMS (c) data management and data base management The artifact demonstrates the student ability to differentiate information in an organizational structure. Analysis is demonstrated by correctly answering 7 out of 14 questions of the type: (a) components of a Database Management System or DBMS (b) techniques used ot store and access data within a DBMS (c) data management and data base management The artifact demonstrates the student ability to differentiate information in an organizational structure. Analysis is not demonstrated by correctly answering less than six 7 out of 14 questions of the type: (a) components of a Database Management System or DBMS (b) techniques used ot store and access data within a DBMS (c) data management and data base management 
Application                                                                                                                                                                                                                                                
Outcomes
4                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
The artifact demonstrates student ability to use principles as they relate to core course topics. Application is demonstrated by correctly answering 13 out of 13 questions regarding organization perspective of managing data, including (a) efficiency (b) privacy and security (c) ethical responsibility (d) strategic advantage The artifact demonstrates student ability to use principles as they relate to core course topics. Application is demonstrated by correctly answering 10 out of 13 questions regarding organization perspective of managing data, including (a) efficiency (b) privacy and security (c) ethical responsibility (d) strategic advantage The artifact demonstrates student ability to use principles as they relate to core course topics. Application is demonstrated by correctly answering 7 out of 13 questions regarding organization perspective of managing data, including (a) efficiency (b) privacy and security (c) ethical responsibility (d) strategic advantage The artifact demonstrates student ability to use principles as they relate to core course topics. Application is not demonstrated by correctly answering less than 7 out of 13 questions regarding organization perspective of managing data, including (a) efficiency (b) privacy and security (c) ethical responsibility (d) strategic advantage 
Content of Communication                                                                                                                                                                                                                                   
Outcomes
2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
The artifact demonstrates student ability to explain accepted practices in managing data base systems. Ability is demonstrated by correctly answering 3 out of 3 questions regarding: (a) duties of data administration (b) duties of data base administration The artifact demonstrates student ability to explain accepted practices in managing data base systems. Ability is demonstrated by correctly answering 2 out of 3 questions regarding: (a) duties of data administration (b) duties of data base administration The artifact demonstrates student ability to explain accepted practices in managing data base systems. Ability is demonstrated by correctly answering 1 out of 3 questions regarding: (a) duties of data administration (b) duties of data base administration The artifact demonstrates student ability to explain accepted practices in managing data base systems. Ability is not demonstrated by answering questions regarding: (a) duties of data administration (b) duties of data base administration 
Technical Skill in Communicating                                                                                                                                                                                                                           
Outcomes
8                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
The artifact demonstrates the student ability to proficiently use terminology related to specific course area. Use of terminology is demonstrated by correctly answering 8 out of 8 questions regarding (a) explaining fundamentals of Structured Query Language or SQL (b) applying fundamentals SQL The artifact demonstrates the student ability to proficiently use terminology related to specific course area. Use of terminology is demonstrated by correctly answering 6 out of 8 questions regarding (a) explaining fundamentals of Structured Query Language or SQL (b) applying fundamentals SQL The artifact demonstrates the student ability to proficiently use terminology related to specific course area. Use of terminology is demonstrated by correctly answering 4 out of 8 questions regarding (a) explaining fundamentals of Structured Query Language or SQL (b) applying fundamentals SQL The artifact demonstrates the student ability to proficiently use terminology related to specific course area. Use of terminology is not demonstrated by correctly answering less than 4 out of 8 questions regarding (a) explaining fundamentals of Structured Query Language or SQL (b) applying fundamentals SQL 

Copyright:

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

Last Updated:11/17/2008 4:11:01 PM