CPTR 319 Database Management Systems

Course Description

Introduction to database management systems, including data modeling, query languages and processing, database design, data integrity and security. Issues related to distributed database systems, object-oriented database systems, and legacy database systems are also discussed.

Purpose, Goals & Objectives

Introduction to database management systems, including data modeling, query languages and processing, database design, data integrity and security. Issues related to distributed database systems, object-oriented database systems, and legacy database systems are also discussed. At the conclusion of this course a student will:

1. Understand the difference between the file-oriented method of building applications and the database method.
2. Learn and practice data modeling using the E-R model.
3. Learn and practice designing normalized databases using the E-R.
4. Learn the fundamentals of the relational data model and understand its role in database implementation.
5. Learn and practice SQL and Relational Algebra.
6. Design and implement a relational database and application in C# using SQL server.
7. Understand the implications and problems of enterprise database systems and study solutions to some of the problems.
8. Understand the role of the "people" involved in a database system.
9. Understand the need for data warehousing and mining applications.
10. Understand the uses of spatial temporal and constraint databases.