Syllabus Entrance
Printer Friendly
Email Syllabus

CS 360 Database Management
Parsons, John Frances


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

F2SS 2006 RA

Faculty

Parsons, John Francis

Title

Academic Director/Adjunct Faculty

Office Location

Bldg 208/Room 41, Randolph AFB, Texas  78150

Office Hours

Monday through Saturday: 9:00am - 7:30pm

Daytime Phone

210-483-2702

Other Phone

210-381-6858

E-Mail

John.Parsons@park.edu

Semester Dates

October 23, 2006 - December 17, 2006

Class Days

--T-R--

Class Time

4:55 - 7:35 PM

Prerequisites

CS219

Credit Hours

3


Textbook:
Modern Database Management, Eight Edition.  Jeffrey A. Hoffer, Mary B. Prescott, Fred R. McFadden.  Pearson, Prentice Hall, Upper Saddle River, New Jersey 07458. 2007.

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:
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: CS 219. 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:
  Core 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. Demonstrate 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. Examine issues of implementing an enterprise database or other DBMS solution such as concurrency, efficiency, management of and security.
  11. Explain the role and issues surrounding the management of data such as efficiency, privacy, security, ethical responsibility, and strategic advantage.
  12. Describe the role of web-enabling databases.


Core Assessment:

Class Assessment:
A variety of methods will be used to assess th learning  that occurs in this course.  Student will create, utillize and modify a database.  Students will be assessed on thier class participation (including attendance), performance on quering the database, performance on examinations and homework.

Grading:

Grading:

Mid-Term Examination.......................................30%

Final Examination (Comprehensive)..................30%

Learning Outcome Assessment Test.................10%

Database Creation project and management...10%

Homework.........................................................10%

Class Participation.............................................10%

Late Submission of Course Materials:

For each class period an assignment is late, points will be deducted.  No course material will be accepted after the last class meeting.

Make Up Examinations:  Only with the approval of the instructor, prior to the exam.

Classroom Rules of Conduct:

1)  Attend class and be prompt.

2)  Excused absences will be granted at the instructor's discretion.

3)  Computers make writing and revising much easier and more productive.  Students must recognize that technology can also cause problems, i.e., printers run out of ink, hard drive crashes, etc.  Students must be responsible for planning ahead and meeting deadlines in spite of technology. 

Course Topic/Dates/Assignments:

Week #1:  Review Syllabus:  Read and be ready to discuss Chapters 1 & 2.

Week #2:  Read and be ready to discuss Chapters 3 & 4/Work on Database.

Week #3:  Read and be ready to discuss Chapters 5 & 6/Work on Database.

Week #4:  Mid-Term Exam.  Read and be ready to discuss Chapter 7  

Week #5:  Read and be ready to discuss Chapters 8 & 9/Work on Database.

Week #6:  Read and be ready to discuss Chapters 10 & 11/Work on Database

Week #7:  Final Comprehensive Exam/Read and be ready to discuss Chapter 12.

Week #8:  Learning Outcomes Assessment Test.  Demonstrate database capabilities.  

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 2006-2007 Undergraduate Catalog Page 87-89

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 2006-2007 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 "W".
  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 2006-2007 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 .

Copyright:

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

Last Updated:9/21/2006 1:26:10 PM