Introduction to DBMS
Designing and Implementing Databases from Scratch for Absolute Beginners
Dr. Hariram Chavan, Prof. Sana Shaikh
- English
- ePUB (mobile friendly)
- Available on iOS & Android
Introduction to DBMS
Designing and Implementing Databases from Scratch for Absolute Beginners
Dr. Hariram Chavan, Prof. Sana Shaikh
About This Book
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.
Table of Contents
1. Database System Concepts and Architecture
2. The Entity-Relationship Model
3. Relational Model and Relational Algebra
4. Structured Query Language and Indexing
5. Relational Database Design
6. Transactions Management and Concurrency and Recovery
Frequently asked questions
Information
CHAPTER 1
Database System Concepts and Architecture
(23 August 1923 - April 18, 2003)
Introduction
- Data means known truth about anything which exists in the real world that can be stored for future use and also has some implicit meaning.
- Data is raw, unorganized facts that need to be processed. Data can be something simple and seemingly random and useless until it is organized.
- For example, the Test scores of a student, Enrolment Number, Email ID, and so on.
Structure
- Difference between data and information
- Understanding the basic concepts of database systems
- Issues with the file-based system
- Major components of the database management system and their functions
- Understanding the role of the database users and database administrator
Objectives
Information: Processed data
- Data can be converted into a meaningful and useful context. Later, it can be communicated to a recipient who uses it to make the decisions.
- When the data is organized, processed, and presented in a given context, it becomes information.
- For example, the subject teacher can process the test scores of the students, and classify them into weak and bright students.
Database
- How many of you have recorded friendsā birthdays in a diary?
- How many of you have written colleaguesā addresses into an address book?
- How many of you have referred to a dictionary for new words?
- Birthdays were organized in the logical order of 'Month'.
- Addresses were stored in a logical order of 'Name'.
- English words with their meaning are arranged in alphabetical order.
- Google Search Engine
- ATM
- Online food ordering
- Online shopping
- Online booking flight
- Data definition: It involves specifying the data types, data structures, and constraints of the data to be stored.
- Data storage: Storing data mostly on secondary storage (or server) which is controlled by DBMS.
- Data manipulation: The three main informal operations are add, modify, and delete; technically inserting, querying, updating and generating reports.
- Concurrent access: The main advantage of the database management systems is concurrent access or data sharing which allows multiple users and programs to access the data concurrently.
- Data protection: The DBMS provides protection against the unauthorized access, system failure, and other catastrophic failures.
- Self-describing nature of a database system
- Programs and data insulation
- Mult...