Syllabus Entrance
Printer Friendly
Email Syllabus

CS 360 Database Management
Sloan, Joseph H.


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 LC
SemesterF2AA2005
FacultySloan, Joseph H.
TitleSenior Instructor
Office LocationLackland AFB
Office HoursAnytime by E-Mail
Daytime Phone210-337-3068
E-Mailjoseph.sloan@park.edu
Joseph.Sloan@DFPS.state.tx.us
Semester Dates24 Oct - 18 Dec 05
Class Days-----F-
Class Time4:45 - 10:10 PM
PerquisitesCS - 219
Credit Hours3

Textbook:
Hoffer, Jeffery A., Prescott, Mary B., McFadden, Fred R., Modern Database Management, 7th Edition, Prentice Hall, 2002, ISBN 0-13-033969-5.

Textbooks can be purchased through 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 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:
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:
Class Participation         8%
Project Presentation     10%
Case Studies (9% each)   18%
Midterm                         20%
DB Project Documentation 14%
Final Final Examination 30%

Students are required to read all assigned material prior to class and be prepared to discuss the examples/assignments provided at the end of each assigned chapter or handed out by the instructor. Discussion of these examples/assignments will be the basis of the class participation grade. Students will also prepare a number of project assignments.
· Case Studies: Each student will complete and turn-in an assigned database case during the week specified below.
· Database Design Project Assignment:  Each student will design a database for their respective work environment (or other appropriate location with which the student is familiar).  This will be a group assignment (no more than 3 students per group).  Using the design techniques in the text, consideration of the organizations business rules, users, decisions supported, data input sources, and usability shall be included.
· A written and oral presentation is due in week seven or eight.
· This project will require a significant effort outside of class, with an emphasis on:
1)  Defining and satisfying requirements
2)  Logical design
3)  Physical design
4)  Implementation plan

Grading:
100-90   A
89-80 B
79-70 C
69-60 D
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:
-----------------------------------------------------------

 Class ActivitiesAssignmentsExams and Case Study Due Dates
Week - 1Introduction to Databasing and Query By Example (QBE) Case Study  discussion
Ch 1, 2 and 9 (pp. 340-348)
Introduction
 
Week - 2Modeling/Entity-Relationship (ER) DiagramsChapter 3 and Appendix A 
Week - 3Enhanced ER DiagramsChapter 4 and Appendix A
Case Study #1 due
Week - 4Logical Database Design/Relational Model/NormalizationChapter 5Case Study #2 due
Week - 5Structured Query Language (SQL)Chapters 7 and 8Midterm Exam due
Case Study #3 due
Week - 6Physical Database Design, Client-Server Architectures,Distributed DatabasesChapters 6, 9 (minus 340-348), 10, and 13Case Study #4 due
Week - 7Data and Database Administration, Data WarehousingChapters 11 and 12Project Presentations
Final Project Documentation Due
Week - 8Object Oriented Approach to DatabasingChapters 14 and 15Final Exam due
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 2004-2005 Undergraduate Catalog
Page 101

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. <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:
http://www.park.edu/disability
 
.

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