Description
Fundamental concepts of database management systems, focusing primarily on the relational and object models. Emphasis on relational model basics, relational algebra and calculus, SQL query optimization, conceptual database design, schema refinement and normalization. Additional topics include concurrency, recovery, security, views, and distributed database. Introduction to the development and maintenance of interactive database-management systems. Prerequisite: CS 318 or BM 318 or CS 160