|
Size: 1901
Comment:
|
Size: 1962
Comment: Should have been capitalized.
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| ## page was renamed from DatabaseManagementSystems/syllabus |
CPTR 319 Database Management Systems
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.
- Understand the uses of spatial temporal and constraint databases.