This course focuses on the client or user side of database systems. It extends the knowledge in the previous course by adding concepts of database management and use. Topics to be covered are file and record organization, basics of query optimization, transaction management and database security.  The course includes an overview of advanced database systems such as Object-Oriented and Object- Relational databases, active databases, deductive databases, multimedia and spatial databases and distributed databases.   Current trends in DBMS are also included. This course is supported by a series of laboratory sessions on database management, administration and security issues.