DATABASE MANAGEMENT SYSTEMS: CONCEPTS, DESIGN AND IMPLEMENTATION
About This Textbook
This textbook provides a comprehensive and structured introduction to the fundamental concepts, design principles, and implementation techniques of Database Management Systems (DBMS). It is designed to guide learners from foundational topics such as data models and relational theory to advanced areas including SQL, schema refinement (normalization), and transaction management.
Database Management Systems: Concepts, Design and Implementation serves as a definitive textbook for mastering relational databases, SQL queries, ER diagram modeling, indexing strategies, transaction processing, and modern NoSQL architectures.
Table of Contents
- Chapter 1: Overview of Database Systems & Architecture
- Chapter 2: Data Modeling Using Entity-Relationship (ER) Model
- Chapter 3: Relational Model & Relational Algebra
- Chapter 4: Structured Query Language (SQL) & Advanced Queries
- Chapter 5: Schema Refinement & Normalization (1NF to 5NF, BCNF)
- Chapter 6: Transaction Processing, Concurrency Control & Recovery Systems
- Chapter 7: Indexing Structures, B-Trees & Hash Indexing
- Chapter 8: Modern NoSQL Databases & Distributed Data Systems
Other Textbooks from Lurnexa Publications
Explore All Textbooks →
ISBN: 978-81-685077-3-9MACHINE LEARNING: A STRUCTURED APPROACH TO ALGORITHMS AND INTELLIGENT SYSTEMS
By Dr. Halavath Balaji, Jogu Saritha, Pallavi B
ISBN: 978-81-685077-4-6FOUNDATIONS OF ARTIFICIAL INTELLIGENCE: CONCEPTS, TECHNIQUES AND APPLICATIONS
By Dr. P. Manikandan, Dr. P. Renukadevi, Dr. J. Nashreen Begum, Dr. D. Banumathy
ISBN: 978-81-685077-8-4DATA STREAMING AND ANALYSIS
By Dr. P. Renukadevi, Dr. Chinmaya Kumar Swain, Dr. Archana Sasi, Mr. Shahad P