Database Management Systems, 2ed

P.S. Gill

ISBN: 9789389307535

308 pages

eBook also available for institutional users 

INR 435


This book on Database Management Systems has been designed to provide an insight into the database concepts. A sincere effort has been made to present the concepts of database normalization, concurrency control, deadlock handling and recovery, etc., in a simple easy-to-understand manner. Since understanding of the query languages is vital for accessing of databases, a large number of queries have been provided to explain the equivalence between SQL, Relational Algebra, Tuple Relational Calculus and Domain Relational Calculus.

  • DBMS overview
  • Entity-Relationship (ER) Modeling
  • Relational Data Model
  • Relational Algebra
  • Tuple Relational Calculus
  • Domain Relational Calculus
  • Structured Query Language
  • Query Optimization Normalization of Relational Schemas
  • Transaction Processing Concepts
  • Concurrency Control
  • Deadlock Handling in Transaction Processing
  • Recovery
  • Distributed Database Systems
  • Brief Introduction to Data Warehousing and Data Mining
  • Index.