CSC 5-415 Database Management Systems

Syllabus

CSC 5-415 Database Management Systems 3hrs. credit .

Mississippi College 2004-2005 Catalog description

Purpose: Database Management Systems is a practical, hands-on approach that prprovides a strong foundation in good database design practice. It provides a methodology for conceptual, logical and physical database design. DBMS gives sthe student an introduction to implementation and management issues as well as an extensive treatment of database languages and standards.

Text

Database Systems: A Practical Approach to Design, Implementation, and Management, 4/e
Thomas Connolly, Carolyn Begg

Objectives

This course provides an introduction to the relational database systems. Topics include the architecture of a database system, foundational principles of databases and database modeling, the query language SQL, normal forms of relations, and issues of data concurrency, security and integrity in the context of multi-user database systems.

1. The student will be able to identify the major components of a database management system.
2. The student will be able to identify the functions of a database management system.
3. The student will be able to design a database system using database management system functions.
4. The student will be able to design and execute querries using SQL.
5. The student will be able to desing and implemment security and authorization functions of a dbms.
6. The studnet will be able to identify and utilize transaction control management functions of a dbms.
7. The student will be able to identify the forms of normalization contained in database structures.
8. The student will be able to identify the necessary criteria and methods for achieving database integrity.
9. The student will be able to identify components and strategies for improving database performance.

Prerequisites

CSC 216.

Topics
I. BACKGROUND.

1. Introduction to Databases.
2. Database Environment.

II. THE RELATIONAL MODEL AND LANGUAGES.

                 3. The Relational Model.
                 4. Relational Algebra and Relational Calculus.
                 5. SQL: Data Manipulation.
                 6. SQL: Data Definition.
                 7. Commercial RDBMSs: Access and Oracle.

                 III. DATABASE ANALYSIS AND DESIGN TECHNIQUES.
                 8. Entity-Relationship Modeling.
                 9. Enhanced Entity-Relationship Modeling.
                 10. Normalization.

IV. METHODOLOGY.

                 11. Methodology - Conceptual Database Design.
                 12. Methodology - Logical Database Design for the Relational Model.
                 13. Methodology - Physical Database Design for Relational Databases.
                 14 Methodology - Monitoring and Tuning the Operational System.

V. SELECTED DATABASE ISSUES.

                 15. Security.
                 16. Transaction Management.
                 17. Query Processing.
                 18. Programmatic SQL.

VI. CURRENT TRENDS.

                 19. Introduction to Object DBMSs.
                 20. Object-Oriented DBMSs - Concepts and Design.
                 21. Object-Relational DBMSs.

VII. EMERGING TRENDS.

                 22. Web Technology and DBMSs.
                 23. Semistructured Data and XML.
                 24.. OLAP and Data Mining.

Academic Integrity

Academic Integrity Policy: online here

This statement on academic honesty in computer science courses is an addendum to the Mississippi College policy 2.19 found at http://www.mc.edu/publications/policies/academic/219.wpd . In a computer science class individual effort is expected. Student misconduct not only includes cheating on tests, but also extends to copying or collaborating on programming assignments, projects, lab work or research unless otherwise specified by the instructor. Using other people's accounts to do your work or having others do your work is prohibited. Close proximity in lab does not mean sharing solutions. NOTE: Discussing logical solutions to problems is acceptable, exchange of code, pseudocode, designs, or procuring solutions from the Web, other texts, the Internet or other resources on or off campus is not acceptable.

First offense: grade of 0 for all parties involved unless the "guilty" party can be determined
Second offense: grade of F in the course!

Class Attendance

Regular attendance is highly recommended. Regardless of attendance, students are responsible for all material covered or assigned in class. Refer to the Mississippi College Policies and Procedures manual for attendance regulations . Since this is a MW class, you may not miss more than 25%, 7 classes, without penality of an automatic grade of F. When a student must miss class for whatever reason, it is his/her responsibility to present a vaild excuse to the instructor as soon as possible. All previously assigned work, exams, and quizes are to be made up within one week. If missed assignments or exams or tests are not made up within the week , then the student will get a grade of 0 on the requirement. Should the student find it impossible to make up the requirements within one week upon returning to normal class attendance, then a mutual agreement with the instructor of the class must be obtained as soon as reasonable regarding times for completion of the delinquent course requirements. The last day to drop this course is Friday, October 28, 2005.

Mechanics

There will be two one-hour tests in class and one final exam . The Schedule for the Semester has these test and final exam dates marked. Make-up tests will be available by pre-arrangement only in case of scheduling conflicts. After the test, make-ups will be available only in case of documented medical emergency. Note: It is the responsibility of the student to contact the instructor and schedule make up exams or missed assignments. Exams and assignsment should be submitted no later than one week after the student returns to normal class attendance.

Besides the exams, there will be regular homework assignments, projects and quizzes in class.

Programming project: In the second half of the semester, we will work with a database management system. There will be a project assigned during that time. The Project will be graded on correctness, style and documentation. The project is due by the last class date.

Grading

The final grade will be computed based on the grades in the tests, the final exam, home works, quizzes and projects according to the following weights.
The grading scale is as follows:

Assessment	Undergraduate	Graduate
Midterm Exam	25%	25%
Final Exam	30%	30%
Homeworks/Written Assignments	20%	10%
Miscellaneous ( *attendance/participation) Subjectives	5%	0%
Project	20%	20%
Graduate Only Research Paper (See Below)		15%
TOTAL	100%	100%
*The folloing percent will be used to compute the final average in this class for undergraduates: If you miss less than 2 classes 5%; If you miss less than 4 classes 3% .

Graduate research paper: 15-20 page double spaced papter on a current topic in database systems. Topic must be approved by professor. The paper must be done on a suitable word processor and should be completely documented with title page and abstract.

Grading Scale: A 90-100; B 80-89; C 70-79; D 60-69; F below 60 %.

Back to Dr. Wiggins Homepage