CS 330 - Databases

3 Credit Hours

Prerequisite: CS 215 or CIS 210 or CS 230 or ITM 200. This course examines the underlying concepts and theory of database management systems. Topics include database system architectures, data models, structured query languages, conceptual and logical database design, and physical organization. The entity-relationship model and relational model are investigated in detail; object-oriented databases are introduced. Integrity constraints, dependencies, and normalization are studied as a basis for formal design. An introduction to transaction management, concurrency control, distributed and Web databases and database recovery are presented.