Database Management Systems: A practical approach

By Viswanadh Manne

This book provides a comprehensive overview of database systems, starting with the fundamental concepts, such as database applications, purposes, data abstraction, models, languages, architecture, and the roles of users and administrators. It introduces database design through Entity-Relationship (ER) diagrams, exploring entities, attributes, relationships, and conceptual design with the ER model. The relational model is covered in detail, including integrity constraints, querying, and logical database design. The book delves into relational algebra and SQL, including basic and advanced queries, set operations, nested queries, and triggers. It addresses schema refinement and normalization, discussing problems of redundancy, decompositions, functional dependencies, and various normal forms up to the fifth normal form. Transaction management is thoroughly explained, focusing on the ACID properties, concurrency control, deadlocks, and crash recovery using ARIES. Finally, the book covers data storage and indexing, detailing file organization, clustered and secondary indexes, hash-based and tree-based indexing, and the use of B+ trees for dynamic indexing. This resource is essential for understanding both the theoretical and practical aspects of database systems.

• Format: Paperback
• Language: English
• ISBN: B0D96KK8DW
• ISBN13: 9798332740954
• Release Date: July 2024
• Publisher: Independently published
• Length: 216 Pages
• Weight: 0.85 lbs.
• Dimensions: 9.0" x 0.5" x 6.0"