CPTR 319 Database Management Systems

Meets:

10:00 MWF in HSC 1307

Prerequisites:

CPTR 215 or CPTR 212

Textbook:

Database System Concepts ISBN: 978-0-07-352332-3

Supplemental Reading:

Supplemental Reading: Projects will include research that requires you to access ACM and IEEE online repositories. These can be found on the library site.

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.

DatabaseManagementSystems/Syllabus (last edited 2025-07-11 14:51:31 by scot)