Description

“Database Management Systems” book provides comprehensive and up-to-date coverage of the fundamentals of database systems. “Database Management System” book presents the fundamental concepts of database management by covering important theoretical results, proofs, figures and examples are used to verify its result. This book provides a concise introduction to the database concepts. It presents the concepts of database normalization, concurrency control, deadlock handling and recovery etc.This book included a number of queries to explain the equivalence between Relational Algebra, SQL, Tuple Relational Calculus and Domain Relational Calculus. Lucid explanations for functional dependencies, multivalued dependencies, join dependencies, lossless-join decomposition, dependency-preservation, etc.The necessity of normalization has also been highlighted. The book is designed for a first course in databases at the undergraduate/ post-graduate level which includes BCA, MCA, B.Sc.IT, B-Tech /M-Tech (CSE).