Theory of Relational Databases

Catalog description

Modern relational databases. Relational algebra, views and queries, normal forms and normalization, tuning and optimization. The entity-relationship model and database design. Overview of other approaches, especially object-oriented databases, data warehouses and data mining, distributed databases and very large applications. Group project, both design and implementation, in an SQL-based environment, such as an SQL Workbench. Prerequisites: CSAS 2121, MATH 1611 or permission of department chair. MATH 2611 recommended.