Introduction To Database Management Systems: (for Doeacc ‘a’ Level)

This book is designed for the course on Introduction to Database Management Systems offered to students taking the DOEACC`s `A` level certificate examination. The book will also be useful to the Diploma students who take a paper on Database Management Systems. Salient Features : Comprehensive coverage of topics like Normalization, ER Model, Relational Algebra, Relational Calculus, Data Modeling, etc. Chapters related to SQL and PL/SQL have been explained with appropriate examples based on a common set of tables. Practical implementation of Embedded SQL has also been explained well. Written in a simple and lucid language keeping in mind the requirements of the target audience. Previous years question papers of DOEACC`s `A` level examinations included at the end of the book as an appendix.-----------------------------------------------------GEN SUPPLEMENT - Solutions to the DOEACC previous years` `A` level questions papers given in the book. Additional exercises and questions. Chapter-wise self-test quiz for the students.------------REST SUPPLEMENT - Solutions to the DOEACC previous years `A` level questions papers given in the book. Additional exercises and questions. Chapter-wise self-test quiz for the students.

Table of Contents

1. Introduction to Database Management Systems
2. Data Modeling
3. Entity Relationship Modeling
4. Enhanced Entity Relationship Model
5. Introduction to Relational Database Management Systems
6. Relational Algebra and Relational Calculus
7. Normalization
8. Structured Query Language
9. Queries and Subqueries
10. DML and DDL Commands
11. PL/SQL Programming
12. Application Programming Interface
13. Buffer Management
14. File Organization in DBMS
15. Transaction Processing
16. Concurrency Control and Deadlock Recovery
17. Backup and Recovery
18. Database Security
19. Data Integrity
20. Distributed Databases
Appendix