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

BACHELOR OF SCIENCE IN MANAGEMENT AND INFORMATION TECHNOLOGY (SPECIAL)

CMPT 41253

Advanced Databases

Status : Elective Pre-requisite : CMPT 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, practical and group work.
End-of- semester examination and continuous assessment.

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

Back