Undergraduate Computer Science

CS U430: Database Design

Studies the design of a database for use in a relational database management system. The entity-relationship model and normalization will be used in example problems. Relational algebra and then the SQL language will be presented. Advanced topics include triggers, stored procedures, indexing, elementary query optimization, and fundamentals of concurrency and recovery. Students will implement a database schema and short application programs on one or more commercial relational database management systems.
Credit hours: 4 SH