Information Database Admin (ITDB)
An advanced course in database modeling drawing distinctions between data modeling, process modeling and implementation. Topics include Structured Query Language (SQL), Entity- Relationship modeling, rational algebra, normalization and relational database modeling, integrity constraints, and database security. Student teams design a database to integrate concepts learned.
An advanced course in update processing and database Topics include serializability, locking, levels of isolation, transaction recovery, checkpoints and media recovery, system catalogs, views, procedural constraints and security. Additional topics include object databases, SQL, procedures functions, and triggers. Student teams implement a database to integrate concepts learned.
Prerequisites: ITDB 4201
Restrictions: *Database Administration*, *General Information Tech*, *Information Design Product*, *Network Plan, Design Mgmt*, *Software Development*, Information Technology - BIT
An advanced course in database architecture and database administration with emphasis on concepts and applications of database processing, multi-tier and client-server architectures, distributed and parallel database systems, and database maintenance.