Introduction to DBMS: Designing and Implementing Databases from Scratch for Absolute Beginners
- Length: 276 pages
- Edition: 1
- Language: English
- Publisher: BPB Publications
- Publication Date: 2022-05-10
- ISBN-10: 9355510268
- ISBN-13: 9789355510266
- Sales Rank: #1451188 (See Top 100 Books)
Database and I: A unified view of the Database
Key Features
- Explains database fundamentals by using examples from the actual world.
- Extensive hands-on practice demonstrating SQL topics using MySQL standards.
- All-inclusive coverage for systematic reading and self-study.
Description
The knowledge of Database Management Systems (DBMS) has become a de facto necessity for every business user. Understanding various databases and how it becomes an integral part of any application has been a popular curriculum for undergraduates.
In this book, you will learn about database design and how to build one. It has six chapters meant to bridge the gap between theory and legit implementation. Concepts and architecture, Entity-relation model, Relational model, Structured Query Language, Relational database design, and transaction management are covered in the book. The ER and relational models are demonstrated using a database system from an engineering college and implemented using the MySQL standard. The final chapter explains transaction management, concurrency, and recovery methods. The final chapter explains transaction management, concurrency, and recovery methods.
With a straightforward language and a student-centered approach, this book provides hands-on experience with MySQL implementation. It will be beneficial as a textbook for undergraduate students, and database specialists in their professional capacity may also use it.
What you will learn
- Acquire a firm grasp of the principles of data and database management systems.
- Outlines the whole development and implementation process for databases.
- Learn how to follow step-by-step normalization rules and keep your data clean.
- MySQL operations such as DDL, DML, DCL, TCL, and embedded queries are performed.
- Develop an understanding of how the transaction management and recovery system operates.
Who this book is for
This book is ideal for anyone who is interested in learning more about Database Management Systems, whether they are undergraduate students, new database developers, or with some expertise. Programming foundations, file system ideas, and discrete structure concepts are recommended but not required.
Cover Page Title Page Copyright Page Dedication About the Authors About the Reviewer Acknowledgement Preface Errata Table of Contents 1. Database System Concepts and Architecture Introduction Structure Objectives Information: Processed data Database File system versus database system The Three-Schema Architecture 1-tier database architecture 2-tier database architecture 3-tier database architecture DBMS System Architecture Database Administrator (DBA) Conclusion Questions 2. The Entity-Relationship Model Introduction Structure Objectives Conceptual modeling of a database Entity-Relationship Model Weak entity Extended Entity-Relationship (EER) model Steps to create an ER diagram Conclusion Questions 3. Relational Model and Relational Algebra Introduction Structure Objective Introduction to Relational Model Relational Model concepts Relational Model constraints and relational database schemas Database Schema Concept of Keys Relational Algebra Relational Calculus Mapping from ER Model to Relational Model Conclusion Questions 4. Structured Query Language and Indexing Introduction Structure Objectives Features of SQL Advantages of SQL SQL Data Types Data Definition Language Data Manipulation Language Data Control Language Transaction Control Language SET Operations String Operations Aggregate functions, Group by, and having clause Views Joins Nested and complex queries Indexing in SQL Cursor Triggers Embedded SQL Conclusion Questions 5. Relational Database Design Introduction Structure Objectives Introduction Pitfalls in Relational-database design Design guidelines for Relational Schema Functional Dependencies Need for Normalization Levels of Normalization Normalization process Conclusion Questions 6. Transactions Management, Concurrency and Recovery Introduction Structure Objective Transaction Transaction State Diagram Serializability – Conflict and View Concurrent executions Concurrency Control Deadlock Deadlock Detection Transaction Control Commands Recovery System Conclusion Questions Index
Donate to keep this site alive
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.