## page was renamed from DatabaseManagementSystems/syllabus
= 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 [[http://library.southern.edu/research/|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.
 1. Learn and practice data modeling using the E-R model. 
 1. Learn and practice designing normalized databases using the E-R. 
 1. Learn the fundamentals of the relational data model and understand its role in database implementation. 
 1. Learn and practice SQL and Relational Algebra. 
 1. Design and implement a relational database and application in C# using SQL Server.
 1. Understand the implications and problems of enterprise database systems and study solutions to some of the problems. 
 1. Understand the role of the "people" involved in a database system.
 1. Understand the need for data warehousing and mining applications.