National University of Sciences and Technology
Home | Back
ISE-830 Advance Database Concepts
Campus SEECS
Programs PG
Session Fall Semester 2016
Course Title Advance Database Concepts
Course Code ISE-830
Credit Hours 3.0
Pre-Requisutes Database Design and Implementation
Course Objectives On successful completion of this course students will be able to:
  • Demonstrate queries in the relational algebra by using operations from set theory (union, intersection, difference, and Cartesian product) and the relational algebra operations developed specifically for relational databases (select/restrict, project, join, and division).
  • Identify appropriate indices for given relational schema and query set.
  • Estimate time to retrieve information, when indices are used compared to when they are not used.
  • Evaluate costs and benefits of various indexing schemes and join algorithms.
  • Explain the concepts involved in transaction processing, concurrency and recovery procedures.
Detail Content
  • Review of Relational Database Design
  • Transaction Processing Concepts and Theory
  • Concurrency Control Techniques
  • Database Recovery Techniques
  • Relational Algebra
  • Physical Storage, Indexing and Hashing
  • Query Processing and Optimization
  • Advance Topics
Text/Ref Books
  • Silberschatz, Korth and Sudarshan (2006): Database System Concepts 5/E, McGraw‐Hill
  • Elmasri and Navathe (2006): Fundamentals of Database Systems 5/E, Addison Wesley
Time Schedule Fall Semester, 2011
Faculty/Resource Person Dr. Khalid Latif (PhD),
Instructor’s Designation: Assistant Professor