Programmes

BACHELOR OF SCIENCE IN SOFTWARE ENGINEERING

SENG 34593

ADVANCED DATABASE DESIGN

Status : Elective Pre-requisite : SENG 12543 Co-requisite : None

 

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

  • Explain the concepts of transaction processing in Database Management Systems
  • Select 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 transactions, problems with uncontrolled concurrency, immediate update, deferred update, check point, time stamping and locking, database performance tuning concepts, DBMS architectures, indexing and query optimization.

Lectures, practical sessions and group work.

End of course unit examination and continuous assessment.

  1. Elmasri, R and Navathe, S B (2011).Fundamentals of Database Systems. Addison Wesley
  2. Coronel, C, Morris, S and Rob, P (2012). Database Systems: Design, Implementation, and Management. Course Technology
  3. Carlos Coronel, Steven Morris (2015, 2013). Database Systems: Design, Implementation, and Management. Cengage Learning.

Back