Database Management Systems: Concepts and Design

Database Management Systems: Concepts and Design provides a comprehensive introduction to the principles, architecture, and practical implementation of modern database systems. The book covers fundamental topics including data models, Entity–Relationship (ER) modeling, relational database design, normalization, SQL, transaction management, concurrency control, indexing, query optimization, database security, backup and recovery, and distributed database systems. It also explores emerging trends such as NoSQL databases, cloud-based data management, big data integration, and database applications in modern enterprises. Through clear explanations, practical examples, design methodologies, and real-world case studies, the book bridges theoretical foundations with industry-oriented practices. Designed for undergraduate and postgraduate students, educators, software developers, and database professionals, this book serves as a valuable resource for building efficient, secure, and scalable database solutions in today's data-driven world.

Dr. Yegireddi Ramesh has been working as Professor & HOD in the Department of CSE at Aditya Institute of Technology and Management (A), Tekkali, Srikakulam permanently affiliated with Jawaharlal Nehru Technological University Vizianagaram, Andhra Pradesh, India. He completed his Bachelor of Science (B.Sc) from Andhra University. He completed a Master of Computer Applications (MCA) from Osmania University, Master of Technology (M.Tech - CSE) from JNTUH Hyderabad and Ph D (CSE) from JNTUK Kakinada. He filed one International Patent, was published WIPO PCT, and also filed 3 Indian Patents (including 1 - Design), among them one granted and other are published in Indian Patent Journal, Govt. of India. He secured one Copyright which was granted by the Copyright Office, Government of India. He also wrote three Textbooks entitled A Methodical Observation of the Analysis of Cryptographic Algorithms, Integrating AI, Big Data, and Cyber Security for next generation Communication and Networking Systems, and Internet of Things. He published 30 Research papers in various reputed (UGC approved, Scopus/ SCI / Web of Science) International and National Journals, magazines, and conferences. He is also a reviewer for International Journal of Research and Development in Engineering Sciences (IJRDES-2582- 4201)). He has more than 24 years of experience in teaching and research and also has good knowledge of Information Security, Networks, Data Science, Blockchain and Internet of Things along with academic subjects, etc. He guided 35 UG and 20 PG academic projects. Currently, he is an active member of ISTE, CSI, and ACM.