Syllabus Entrance
Printer Friendly
Email Syllabus

CS 360 Database Management
Haynie, Glyn E.


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

F2A 2006 BE

Faculty

Haynie, Glyn E.

Title

Instructor

Office Location

Rm 105

Office Hours

30 minutes before and after class

E-Mail

glyn.haynie@austin.rr.com

Semester Dates

F2A 2006

Class Days

--T-R--

Class Time

8:00pm - 10:40pm

Prerequisites

CS 219

Credit Hours

3


Textbook:

Hoffer, Jeffrey A., Prescott, Mary B., McFadden, Fred R., Modern Database Management, Eighth Edition, Prentice Hall, 2005, ISBN 0-13-221211-0.

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.

Park University Online Bookstore - Select "Distance Learning - Graduate," or "Distance Learning Internet," and then click on the appropriate course code (ex. AC 201, PA 501) to see the list of required and optional texts for each course that you are enrolled in.

Advising - Park University would like to assist you in achieving your educational goals. Your Campus Center Administrator can provide advising to you, please contact them for assistance. If you need contact information for your Campus Center, click here.

Online Tutoring Services - Park University has arranged for Online students to receive five hours of free access to Online tutoring and academic support through Smarthinking. If you would like Online tutoring, please contact me to receive their recommendation and information on how to access the Online tutoring.

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.

Online Classroom Technical Support - For technical assistance with the Online classroom, email helpdesk@parkonline.org or call the helpdesk at 866-301-PARK (7275). To see the technical requirements for Online courses, please visit the http://parkonline.org website, and click on the "Technical Requirements" link, and click on "BROWSER Test" to see if your system is ready.

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.

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:

Each week we will focus on the various aspects of database technology from the basic terms of the discipline, through data modeling, to the concepts utilized in the physical design and implementation of a database. The course will be conducted through a combination of reading assignments, with associated topical weekly discussion questions which are posted on the appropriate public discussion threads, weekly homework assignments and weekly internet research assignments which are submitted to the appropriate private drop boxes, and a proctored comprehensive final exam. This course will build on the global and multinational aspects of databasing including the international nature and accessibility of information, and the de facto standardization of technology both for a vendor provided database management system (DBMS) and language, the structured query language (SQL).

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.    Complete the following reading assignments prior to coming to class.

1)                  Chapter(s) to be presented that night.

2)                  Review questions at the end of each chapter.

B.     Complete all homework assignments when scheduled.

C.     Complete all examinations when scheduled.

D.    Late work is not accepted.

Grading:

Make-up examinations must be scheduled prior to the date of the examination.  Assignments are due on the due date.  Late work is not accepted.  The final grade will be determined as follows:

 

Mid Term Examination                 25%                                         A = 100 - 90

Final Examination                         25%                                         B =   89 - 80

Project                                         25%                                         C =   79 – 70

Homework/Participation               25%                                         D =   69 – 60

                                                                                                    F =   below 60

Late Submission of Course Materials:

Late work will not be accepted.

Classroom Rules of Conduct:

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. 

Definitions

Academic dishonesty includes committing or the attempt to commit cheating, plagiarism, falsifying academic records, and other acts intentionally designed to provide unfair advantage to the students.

  • Cheating includes, but is not limited to, intentionally giving or receiving unauthorized aid or notes on examinations, papers, laboratory reports, exercises, projects, or class assignments which are intended to be individually completed.  Cheating also includes the unauthorized copying of tests or any other deceit or fraud related to the student's academic conduct.
  • Plagiarism involves the use of quotation 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 assignments (any portion of such) prepared by another person, or incorrect paraphrasing.
  • Falsifying academic records includes, but is not limited to, altering grades or other academic records.
  • Other acts that constitute academic dishonesty include:
    • Stealing, manipulating, or interfering with an academic work of another student or faculty member.
    • Collusion with other students on work to be completed by one student.
    • Lying to or deceiving a faculty member.

Procedure

In the event of alleged academic dishonesty, an Academic Dishonesty Incident Report will be submitted to an Online Academic Director who will then investigate the charge.  Students who engage in academic dishonesty are subject to a range of disciplinary actions, from a failing grade on the assignment or activity in question to expulsion from Park UniversityPark University's academic honesty policy and related procedures can be found in full in the 2004-2005 Park University Undergraduate and Graduate Catalogs.

 
Attendance

Professors are required to keep attendance records and report absences throughout the term. Excused absences can be granted by the instructor for medical reasons, school sponsored activities, and employment-related demands including temporary duty. The student is responsible for completing all missed work.  Any student failing to attend class for two consecutive weeks, without an approved excuse from their instructor, will be administratively withdrawn and notified via email that you have been withdrawn and a grade of "WH" will be recorded.

An attendance report of "P" (present) will be recorded for students who have logged in to the Online classroom at least once during each week of the term.  PLEASE NOTE:  Recording of attendance is not equivalent to participation.  Participation grades will be assigned by each individual instructor according to the criteria in the Grading Policy section of the syllabus.

For more details on Park University on page 100 of the Park University Undergraduate Catalog or page 14 of the Park University Graduate Catalog.

Students are expected to spend a substantial amount of time online and offline each week including but not limited to responding to the weekly conference discussions, sending/receiving Email, reading and viewing online lectures, completing online quizzes and tests, and conducting research over the World Wide Web.  A rule of thumb is that you should spend a minimum of approximately 4-5 hours per week online reviewing course content, and engaging in the conference discussion and an additional 4-6 hours per week on readings, preparing assignments, or examinations.

Course Topic/Dates/Assignments:

Week        Class/Discussion/Reading Assignments

 

      Oct 24       Class Policies: Introduction to Course,

Description of Project Requirements             

and Examinations

The Database Environment                                                     Chapter 1

 

     Oct 26        The Database Development Process                                       Chapter 2

                        Data Modeling Tools and Notation                                         Appendix A

                                               

     Oct 31        Modeling Data in the Organization                                          Chapter 3       

 

     Nov2          The Enhanced E-R Modeling and Business Rules                    Chapter 4

 

     Nov 7         Logical Database Design and the Relational Model                 Chapter 5

                       

     Nov 9         Physical Database Design and Performance                            Chapter 6

 

    Nov 14        Lab                                                                                         

 

    Nov 16        Mid Term Examination

 

    Nov 21        Introduction to SQL                                                               Chapter 7

 

    Nov 23        Advanced SQL                                                                      Chapter 8       

                       

    Nov 28        The Client Server Database Environment                                Chapter 9

 

    Nov 30        The Internet Database Environment                                        Chapter 10

 

    Dec  5          Data Warehousing                                                                 Chapter 11

 

    Dec 7           Data and Database Administration                                         Chapter 12

 

    Dec 12         Overview                                                                              Chapter 13-15

                        Project Due    

 

    Dec 14         Final Examination

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:10/19/2006 12:54:30 PM