There is a group project requiring use of Microsoft Access Software. The base library has this software, but I recommend you have a personal copy to work on at home.
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
I expect students to prepare for each class by reading their assignments and completing their homework. I will lecture and encourage interactive discussion on the material. At the end of each class, I will host a lab on Microsoft Access. The purpose of the lab is to expose students to the capabilities of Access and prepare them to complete the database project due at the end of the term.
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.
Homework, examinations, group database project, and presentation.
Mid-Term Exam 25%
Final Exam 25%
Group Project 25%
Late Submission of Course Materials:
Homework is assigned to ensure that all of the learning objectives are covered. The homework deals with modeling, SQL and normalization. Homework is assigned for each chapter and is due at the beginning of the class period. Homework not turned in on time will not receive credit. If a student will miss class, the homework must be e-mailed to the instructor by 08:00 AM of the date due. Students arriving late to class will not receive credit for their homework unless arrangements are made in advance.
The group project must be turned in on time or no credit will be given.
Classroom Rules of Conduct:
All reading assignments should be completed before the class period in which the assignment is to be discussed. Come to class prepared to discuss the reading assignment. Regular class meeting times will be used to discuss concepts and insights for each session's reading assignment.
Classroom participation is encouraged.
Topic Date Assignments
Chapter 1 - Introduction to Database Processing / Sat, Oct 23
Chapter 2 - Relational Model: Introduction, QBE, and Relational Algebra
Chapter 3 - Relational Model: SQL / Sat, Oct 30 / Homework #1 Due
Chapter 4 - Relational Model: Advanced Topics
Chapter 5 - Database Design: Normalization / Sat, Nov 06 / Homework #2 Due
Midterm (Chapters 1 - 5) / Fri, Nov 12
Chapter 6 - Database Design Methodology / Sat, Nov 13 / Homework #3 Due
Chapter 7 - Functions of a Database Management System
Chapter 8 - Database Administration /Sat, Nov 20 / Homework #4 Due
Chapter 9 - Advanced Topics
Final (Chapters 6 - 9) / Fri, Dec 10
Project Presentations / Sat, Dec 11 / Project Due
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 Undergradute Catalog Page 101
I will enforce Park policy regarding academic honesty.
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 2004-2005 Undergraduate Catalog Page 101
I will enforce Park policy regarding plagiarism.
Instructors are required to maintain attendance records and
to report absences via the online attendance reporting system.
Park University 2004-2005 Undergradute
Catalog Page 100
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 .
This material is copyright and can not be reused without author permission.