Data Base Concepts

Catalog description

Prerequisite: CIS 265. A comprehensive introduction to database concepts. Emphasis is given to the relational database model. Discussion of data modeling approaches, normalization and database design theory, data definition and manipulation languages, data architecture for storage of large data sets, indexing techniques for effective data retrieval, query processing and optimization, security, concurrency control and recovery mechanisms. Lab experience using various commercial DBMS systems with a focus on ‘how to use the tools.’