Guide to Database Management System

by Satish Jain

This guide contains questions with answers likely to be asked in the question paper set for DBMS for B.E. (Comp. Sc.), MCA, M.Sc(IT), PGDCA and other IT related examinations. It includes eight Chapters and each chapter contains important questions with answers. This guide covers questions related to concepts of DBMS architecture, administration and fundamentals of database design. It covers topics like entity-relationship diagram, normalization, aggregation, functional dependencies and clustering. It contains questions related to transaction processing, security concurrency control, database recovery and query processing. Separate chapters are added to give coverage of SQL and Relational Algebra and Calculus. Ample number of diagrams are used to illustrate the answers for easy understanding. Sample papers with answers are also added at the end of this guide to evaluate progress buy readers. Separate section is added to cover short questions with answers to prepare readers to answers objective type of questions that might be asked in examination and to assess their comprehension about the entire subject. A glossary of numerous technical terms is included for easy understanding of the subject matter.

169 pages, Paperback

Published October 1, 2006