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:
- Understand the difference between the file-oriented method of building applications and the database method.
- Learn and practice data modeling using the E-R model.
- Learn and practice designing normalized databases using the E-R.
- Learn the fundamentals of the relational data model and understand its role in database implementation.
- Learn and practice SQL and Relational Algebra.
- Design and implement a relational database and application in C# using SQL Server.
- Understand the implications and problems of enterprise database systems and study solutions to some of the problems.
- Understand the role of the "people" involved in a database system.
- Understand the need for data warehousing and mining applications.