Syllabus Entrance
Printer Friendly
Email Syllabus

CS 360 Database Management
Lamont, James Francis,, Jr.


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 WT
SemesterS1L2006
FacultyJames Lamont
E-Mailjames.lamont@park.edu
Web Pagehttp://www.jimlamont.com
Semester DatesMonday, January 09, 2006 - Sunday, March 05, 2006
Class Days-M-W---
Class Time4:55 - 7:35 PM
Credit Hours3

Textbook:
Database Management Systems: Designing and Building Business Applications. 3rd Edition.
McGraw-Hill Irwin; 2005
ISBN 0-07-297312-9 (Book and CD)  Book only: 0-07-291919-1.

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 facilitator's educational philosophy is one of interactiveness based on lectures, readings, quizzes, dialogues, examinations, internet, videos, web sites and writings. The facilitator will engage each learner in what is referred to as disputatious learning to encourage the lively exploration of ideas, issues and contradictions.

Learning Outcomes:

At the end of the course the successful student should be able to:
Describe a relational database and object-oriented database.
Describe components of a database management system and the techniques used to store and access data within the DBMS.
Utilize modeling software to build a database design.
Describe normalization and perform normalization of a database model.
Understand the basic fundamentals of Structured Query Language (SQL).
Use SQL to create the tables within a database and queries for updating tables.
Utilize SQL to build queries to extract data from multiple tables based on selection criteria.
Describe the duties of the database administrator.
Describe the creation and use of metadata and data dictionaries.
Understand issues of implementing an enterprise database or other DBMS solution such as concurrency, efficiency, management of and security.
Understand the role and issues surrounding the management of data such as efficiency, privacy, security, ethical responsibility, and strategic advantage.
Describe and understand the role of web-enabling databases.

Course Assessment:
See schedule.

Grading:
Current Events . . . . . . 20 points
Group Projects  . . . . .  20 points
Participation  .  . . . .  40 points
Mid-Term . . . . . . . . . 100 points
Final . . . . . . . . . . .  . 100 points
Exercises  . . . . . . . . 120 points

Late Submission of Course Materials:
Late papers will be marked down accordingly and a failing grade assigned if not submitted before the final examination.

Classroom Rules of Conduct:
Students are expected to attend all classes and be on time.  Roll will be checked each class meeting.  Classes missed for legitimate reasons, such as illness or temporary duty, are excusable; however, the student must turn in homework assignments as well as typewritten chapter notes and comments the next class meeting following the absence (a partial failing grade for class participation will be assessed for late chapter cases or unexcused absences).

DateDayChapterTopicAssignment Due
Jan 9thMonday1IntroductionReview Questions 3 & 4
Exercise Question 3
DUE FIRST NIGHT OF CLASS
Jan 11thWednesday2Database DesignReview Question 1 & 10
Exercise Question 3
Jan 16th
Martin Luther King Day
Monday3Data NormalizationReview Questions 3 & 11
Exercise Question 4
Jan 18thWednesday4Data QueriesReview Questions 1 & 10
Exercise Question 5
Jan 23rdMonday5Advanced Queries and Sub-queriesReview Questions 4& 5
Exercise Question 9
Jan 25thWednesday5 AppendixAdvanced Queries and Sub-queriesCurrent Event Presentation
Jan 30thMondayMid Term  
Feb 1stWednesday6 Review Questions 1& 4
Exercise Question 6
Feb 6thMonday7 Review Questions 1& 4
Exercise Question 1
Feb 8thWednesday8 Review Questions 1 & 3
Exercise Question 6
Feb 13thMonday9 Review Questions 1 & 8
Exercise Question 1
Feb 15thWednesday10 Review Questions 1& 6
Exercise Question 2
Feb 20th
President's Day
Monday10  
Feb 22ndWednesdayGroup Project Group Project
Feb 27thMondayReview Current Event Presentation
March 1stWednesdayFinal  

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.

  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 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
 
.

Copyright:
This material is copyrighted and cannot be reused without author permission