CS 360 Database Management
S1A 2008 BE
Associate Professor of Computer Science
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)
Austin Campus - Room 109
Mondays through Thursdays from 3:00pm to 5:00pm or by appointment
(512) 385-7275 ext 209
Monday, January 14, 2008 through Sunday, March 09, 2008
5:10 - 7:50 PM
Textbook: Hoffer, Modern Database Management, 8th Edition,
Prentice Hall, 2006, ISBN 978-0132212113.
Textbooks can be purchased through the MBS bookstore
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 firstname.lastname@example.org or call 800-927-3024Resources for Current Students - A great place to look for all kinds of information http://www.park.edu/Current/.
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
Link to Class RubricClass Assessment: Students are expected to:
A. Complete the reading assignments for the week as indicated in the Class Schedule.
B. 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. They will also have to post a weekly summary of the lessons they have learnt in the “Lessons learnt in the week” discussion thread. Each posting should be of at least 100-words-length.
C. Complete all homework/assignments when scheduled. There will be at least 4 assignments in the semester.
E. Complete all examinations when scheduled.
Online participation 20%
Mid Term Exam 20%
Final Exam 20%
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.
Postings to all discussion threads must be done in their appropriate week. No points will be granted for late (or by the same token, early) posts.
Classroom Rules of Conduct:
LAST DAY TO DROP: Monday, January 21, 2008
LAST DAY TO WITHDRAW: Sunday, February 17, 2008
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.
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.
Homework Due Date
Required Reading for the Week
Online Activity for the Week
Monday Jan. 14, 2008
Introduction to the course.
Chapter 1. The Database Environment.
Chapters 1 and 2 from textbook.
Post answers to questions on the appropriate discussion thread of the week.
Post comments on the answers of your peers.
Post a summary of lessons learnt in the appropriate discussion thread.
Wednesday Jan. 16, 2008
Chapter 2. The Database development Process.
Monday Jan. 21, 2008
Chapter 3. Modeling Data in the Organization.
Assignment 1 Given
Chapters 3 & 4 from textbook.
Wednesday Jan. 23, 2008
Chapter 4. The Enhanced E-R Model and Business Rules
Monday Jan. 28, 2008
Chapter 5. Logical Database Design and the Relational Model (begin)
Chapter 5 from textbook.
Wednesday Jan. 30, 2008
Chapter 5. Logical Database Design and the Relational Model (end)
Assignment 2 Given
Assignment 1 Due Date
Monday Feb. 4, 2008
Chapter 7. Introduction to SQL
Chapters 7 & 8 from textbook.
Wednesday Feb. 6, 2008
Chapter 8. Advanced SQL.
Monday Feb. 11, 2008
Chapter 6. Physical Database Design and Performance.
Assignment 3 Given
Assignment 2 Due Date
Chapters 1 to 5 & 7 to 8 from textbook for Exam 1.
No discussion threads this week.
Wednesday Feb. 13, 2008
Midterm Exam.(Chapters 1-5,7-8).
Chapter 9: The Client/Server Database Environment.
Monday Feb. 18, 2008
Chapter 10. The Internet Database Environment.
Chapter 13: Overview: Distributed Databases
Chapters 10, 11 & 13 from textbook.
Wednesday Feb. 20, 2008
Chapter 11. Data Warehousing.
Assignment 4 Given
Assignment 3 Due Date
Monday Feb. 25, 2008
Chapter 12. Data and Database Administration.
Chapters 12 & 14 from textbook.
Wednesday Feb. 27, 2008
Chapter 14. Overview: Object Oriented Data Modeling
Monday Mar. 3, 2008
Chapter 15. Overview: Object Oriented Database Development.
Assignment 4 Due Date
All textbook chapters for Final Exam.
Wednesday Mar. 5, 2008
Final Exam (Comprehensive).
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 2007-2008 Undergraduate Catalog Page 85-86
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 2007-2008 Undergraduate Catalog Page 85
Attendance Policy:Instructors are required to maintain attendance records and to report absences via the online attendance reporting system.
Park University 2007-2008 Undergraduate Catalog Page 87-88
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 .
Last Updated:11/28/2007 5:02:51 PM