CS 360 Database Management
S2AA 2006 LC
Sloan, Joseph H.
March 13 - May 7 2006
4:45 - 10:10 PM
Textbook: Hoffer, Jeffrey A., Prescott, Mary B.,McFadden, Fred R., Modern Database Management, Sixth Edition, Prentice Hall, 2002, ISBN 0-13-033969-5.
Supplemental Resource Materials: Textbook PowerPoint slides and Internet researched material
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 up, modifying, and querying a database. Prerequisite: CS219. 3:0:3
Educational Philosophy: : The instructor's educational philosophy is based on the concept of applied learning. It is believed that in order to fully benefit from an education, students must aggressively read and study course material on a routine basis, continually applying and building upon their new found knowledge. Students are expected to be well prepared to discuss the text examples and assignments provided in each chapter. Discussion of these examples and assignments will be part of the basis of the class participation grade. Students should expect to invest at a minimum of 10 hours of focused time studying and working on the case studies and group project each week.
Learning Outcomes: Core Learning Outcomes
Grading: 100-90 A
Below 60 F
Late Submission of Course Materials: Homework must be turned in at the beginning of class on the day it is due. The due date of homework will be annotated at the bottom of each assignment. Late assignments will be accepted up to the start of the next class meeting but will incur a 10-point (out of 100) reduction in score each calendar day it is late. Late homework will not be accepted after the start of the next class meeting and will receive an automatic zero for a grade. The instructor may modify the due dates and it is the student's responsibility to adjust to the assignment turn in accordingly.
Classroom Rules of Conduct: DO NOT SURF THE INTERNET OR RUN OTHER APPLICATIONS WHICH ARE NOT ASSOCIATED WITH THE DISCUSSIONS IN CLASS. TYPING ON THE KEYBOARD AND CLICKING THE MOUSE IS DISTRACTING AND DISRESPECTFUL TOWARD OTHER STUDENTS TRY TO LEARN.
While in class, the class should be your primary focus. Disruptions of class due to communications devices have become so prevalent that they are a major distraction in class (to you, to the instructor and to other students). For this reason such devices must not be brought to class or must be inactivated during the class lecture.
Course Topic/Dates/Assignments: 17 Mar - Introduction to Databasing and Query by example (QBE),Case Study # discussion. Chapter 1,2 and 9 (pp340-348). Introduction
24 March - Modeling/Entity-Relationship(ER) Diagrams. Chapter 3 and Appendix A.
31 March - Enhanced ER Diagrams. Chapter 4 and Appendix A. Case study #1 Due.
07 April - Logical Database Design/Relational Model/Normalization. Chapter 5. Case Study # 2 Due.
14 April - Structured Query Language (SQL). Chapter 7 and 8. Midterm exam. Case Study #3 Due.
21 April - Physical Database Design, Client-Server Architectures, Distributed databases. Chapter 6,9, 10,13. Case Study 4 Due.
28 April - Data and Database Administration, Data Warehousing. Chapter 11 and 12. Project Presentations. Final project documentation due.
05 May - Object Oriented Approach to Databasing. Chapter 14 and 15. Final exam. Project presentations. Final presentation slides due.
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 2005-2006 Undergraduate Catalog Page 85-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 2005-2006 Undergraduate Catalog Page 85-87
Attendance Policy:Instructors are required to maintain attendance records and to report absences via the online attendance reporting system.
Park University 2005-2006 Undergraduate Catalog Page 89
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: http://www.park.edu/disability .