List of Topics: DBMS concepts and architectures (2 hours) Database models and languages: relational model, relational algebra, SQL, triggers, object-relational model, XML (10 hours) Database logical design: ER model, design methodologies, normalization theory (8 hours) Physical organizations and query processing: access structures, evaluation of query operations and query pipelines, query optimization (8 hours) Database security (8 hours) Transaction management, concurrency control, and recovery (4 hours) Advanced topics in database systems (4 hours) 2005.11