CSC 174. Advanced Database Management Systems. Enhanced Entity-Relationship (EER) modeling; relational database design based on EER; SQL views; integrity constraints and triggers; stored procedures and functions; database programming techniques; query processing and optimization; transactions concurrency and recovery techniques; relational decomposition and normalization algorithms; database schema and data security. Prerequisite: CSC 131, CSC 134. Graded: Graded Student. Units: 3.0.