B.Sc.in Management and Information Technology (Interim)

BACHELOR OF SCIENCE IN MANAGEMENT AND INFORMATION TECHNOLOGY

IMIT 31022

Advanced Databases

Status :  Elective Pre-requisite :IMIT 12043 Co-requisite : None

 

On completion of this course, the student should be able to:

  • Explain the concepts of transaction processing in Database Management Systems and mechanisms for dealing with transaction management and security of database systems.

Relational Algebra. Query optimization: different approaches of building query, query trees, query graphs. Database security. Concurrency & recovery: transaction, types of transaction, problems with uncontrolled concurrency, immediate update, differed update, check point, time stamping and locking.
Lectures, practicals and group work.
End-of- semester examination and continuous assessment.

  1. Elmasri R. and Navathe S. B., “Fundamentals of Database Systems”, 4th Edition, 2003, Addison Wesley.

Back