Database Management Systems (BCA-52T-113)

Database Management Systems (BCA-52T-113) is an English medium BCA II Semester textbook for University of Rajasthan, PDUS, RRBM and MSB students. The book starts with database system concepts and architecture: the history and terminology of DBMS, file system versus DBMS, RDBMS and object oriented databases, Codd's rules, data independence, schemas, database languages, users and data models. Data modelling follows with the ER model, keys, mapping constraints, generalization, specialization and aggregation. The relational model is covered through constraints, ER and EER mapping, and relational algebra and calculus, leading to database design with functional dependencies, normalization and decomposition. Transaction management explains ACID properties, serializability, isolation, checkpoints and deadlock handling, and a chapter on recovery and security covers log based recovery, shadow paging and authorization. The SQL chapter deals with data types, commands, operators, views, indexes, subqueries, aggregate functions, joins and set operations, and a DBMS lab section closes the book. Written by Dr. Mahaveer Kumar Sain, Dr. Dharmveer Yadav, Dr. Surendra Choudhary and Vipin Singh as per the latest syllabus, the 2024 edition has 296 pages. Useful for BCA II Semester students studying paper BCA-52T-113.