| |
Nov 24, 2024
|
|
|
|
|
IT 117 - Database Management SystemsSemester Hours: 3
Fall, Spring
Advanced course on database management systems (DBMS) concentrating on the relational data model and the SQL language. Covers theory of the relational data model contrasting it with earlier models. Database design is developed in the context of the overall design of an information system in accounting, finance, management, marketing, and other application areas. Topics include conceptual, logical, and physical database design, including data normalization and integrity constraints. Distributed database systems in a global business environment and issues related to data accuracy, security, privacy, and threat to individual rights are explored. Course requires designing and implementing databases using a mainframe and/or micro DBMS.
Prerequisite(s)/Course Notes:
IT 014 or CSC 005 ; junior class standing or above.
Add to Personal Catalog (opens a new window)
|
|