|
Size: 2001
Comment:
|
← Revision 5 as of 2025-07-11 14:51:31 ⇥
Size: 1933
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 11: | Line 11: |
| 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. | 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. |
| Line 16: | Line 16: |
| 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: | 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: |
| Line 23: | Line 23: |
| 1. Design and implement a relational database and application in C# using SQL server. | 1. Design and implement a relational database and application in C# using SQL Server. |
| Line 27: | Line 27: |
| 1. Understand the uses of spatial temporal and constraint databases. |
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.