CSC 204. Data Models for Database Management Systems. Database management system (DBMS) architecture; database file organizations and access methods; the relational model and relational algebra; SQL query language; introduction to query optimization; concurrent transaction processing and backup and recovery; applications using embedded SQL, object types, and stored procedures; database analysis and design notations: EER, UML, and XML; web database environments; database security and administration throughout course. Note: Not intended for students who have completed CSC 174. Prerequisite: Fully classified graduate status in Computer Science or Software Engineering. Graded: Graded Student. Units: 3.0.