University of Information Technology

Advanced Database Management System

Course Description

This course provides the theory and practice of advance database management systems. It covers the principles of database systems and emphasizes how they are used in developing data-intensive applications. Topics will include the fundamental of how data is stored and manipulated in relational database and xml database, building complex database objects and user defined data types in object oriented database, parallel and distributed database, establishing and maintaining database security and authorization.

The aims of this course are:

  • To introduce students the database management administration concepts and practice on the oracle environment.
  • To get an understanding of the theoretical and practical aspects of different types of databases and database management systems.
  • To write Structured Query Language (SQL) commands and XQuery commands for data definition and manipulation such as create tables and indexes, select/insert/update/delete data in Relational database and XML database.

Intended Learning Outcomes

Upon the successful completion of this course, students should be able to:

  • establish an in-depth understanding of Database Administration using the Oracle DBMS interfaces.
  • understand the functions of the Oracle Database Server and Oracle Database Client.
  • create, maintain and manipulate an Oracle Database.
  • discuss the emerging research issues in database systems and application development.

Text and References Books


  1. Principles of Distributed Database Systems, Third Edition, M.TamerOzsu, PartickValduriez
  2. Database Management System, Third Edition, RamakrishnanGehrke
  3. Professional XML Databases, Kevin William
  4. OCA Oracle Database 11g: SQL Fundamentals I Exam Guide (Exam 1ZO-051)


  1. Distributed Database Management Systems: A Practical Approach by Saeed K. Rahimi and Frank S. Haug (Aug 2, 2010).
  2. Distributed Database Systems (International Computer Science Series) by David Bell and Jane Grimson (Feb 26, 1992).

Assessment system

Evaluation Marks Percentage
Project Presentation 20 Marks 20%
Individual Assignment 10 Marks 10%
Tutorial 10 Marks 10%
Final Examination 60 Marks 60%