Database Management System

This compact text on Database Management System is a perfect blend of theoretical and practical aspects. From basics to applications, it provides a thorough and up-to-date treatment of the subject. The book, in the beginning, builds a strong foundation of relational database management system and then deals with query language, data manipulation, transaction processing, data warehouse, data mining, and application programming. The text is supported by clear illustrations, sufficient figures and tables, and necessary theoretical details to understand the topics with clarity. Besides, numerous solved examples and chapter-end exercises will help students reinforce their problem-solving skills. The book adopts a methodological approach to problem solving.

Primarily intended for both degree and diploma students of Computer Science and Engineering, the book will also be of benefit to the students of computer applications and management.

Preface

1. Database Systems

2. Modelling a Database

3. Modelling with E-R Diagram

4. Principles of Relational Database Management Systems

5. Relational Database Design

6. Structured Query Language

7. Information Retrieval and Data Manipulation

8. Programming with PL/SQL

9. Query Processing and Optimization

10. Concurrent Transaction Processing

11. Database Recovery

12. File Organization, Indexing and Hashing

13. Data Warehousing and Data Mining