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, modifying, and querying a database. Pre-requisite: CS219. 3:0:3
Educational Philosophy: The facilitator's educational philosophy is one of interactiveness. Lectures, readings, quizzes, dialogues, examinations, internet, videos, web sites and writings will be used to present a variety of exposure and opportunities for the student. 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: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.
Course Assessment: Examinations, quizzes, projects, discussion, homework and presentations will be used in assessment of the student's learning.
Grading: Homework and quizzes: 100 points
Midterm Examination: 100 points
Final Examination: 100 points
Final Project: 100 points
Group project: 100 points
Class participation: 100 points
Late Submission of Course Materials: Any course work submitted late, without due cause, will have 10% of the total points possible deducted from the graded score for each day late.
Classroom Rules of Conduct: No food or beverages are allowed at workstations. Computers are to be used only at the direction of the instructor during class sessions. Children are not allowed in the computer lab during class sessions. Cell phones must be off or in silent mode.
Course Topic/Dates/Assignments: Readings will be assigned from the following:
1 Laboratory familiarization and Ch. 1 introduction to database processing
2. Chps. 2, 3
3. Chps. 4, 5
4. Chps. 6, 7, 8
5. Review and midterm examination
6. Chps. 9, 10, 11
7. Chps. 12, 13
8. Chps. 14, 15
9. Review and final examination
Laboratory work will be assigned at various times during the course. This schedule is tentative and may be adjusted to ensure a more successful learning environment.
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.
Park University 2005-2006 Undergraduate Catalog Page 897. It is the student's responsibility to contact the instructor regarding any missed classes or assignments.
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:
Copyright:This material is copyright and can not be reused without author permission.