This book on creation and management of database systems provides an in-depth analysis of several real-world examples of database applications. This textbook offers a clear and comprehensive overview of the fundamentals, principles, and, in particular, sophisticated instrumentation techniques used in database systems. It discusses the database as an essential component of a software system, as well as a valuable, mission critical corporate resource.The book examines different database concepts, principles, design, implementation, and management challenges. Each chapter is carefully divided into concise, reader-friendly chunks, with itemization of the key elements to remember. It solves database system challenges in a methodical and pragmatic manner. Diagrams and pictures can also be used to summarise key topics in order to improve learning. This book does an outstanding job of providing an overview of the many different aspects of database systems. The book is intended for all the readers from multidisciplinary backgrounds.
Author(s): Adele Kuzmiakova
Publisher: AclerPress
Year: 2022
Language: English
Pages: 262
Cover
Title Page
Copyright
ABOUT THE EDITOR
TABLE OF CONTENTS
List of Figures
List of Tables
List of Abbreviations
Preface
Chapter 1 Introduction to Database Systems
1.1. Introduction
1.2. Why Databases?
1.3. Data Vs. Information
1.4. Introducing the Database
1.5. Importance of Database Design
1.6. Evolution of File System Data Processing
1.7. Problems with File System Data Processing
1.8. Database Systems
References
Chapter 2 Data Models
2.1. Introduction
2.2. Importance of Data Models
2.3. Data Model Basic Building Blocks
2.4. Business Rules
2.5. The Evolution of Data Models
References
Chapter 3 Database Environment
3.1. Introduction
3.2. Three-Level Ansi-Sparc Architecture
3.3. Database Languages
3.4. Conceptual Modeling and Data Models
3.5. Functions of a DBMS
3.6. Components of a DBMS
References
Chapter 4 The Relational Model
4.1. Introduction
4.2. Brief History of the Relational Model
4.3. Terminology
4.4. Integrity Constraints
4.5. Views
References
Chapter 5 Database Planning and Design
5.1. Introduction
5.2. The Database System Development Lifecycle
5.3. Database Planning
5.4. Definition of the System
5.5. Requirements Collection and Analysis
5.6. Database Design
References
Chapter 6 Data Manipulation
6.1. Introduction
6.2. Introduction to SQL
6.3. Writing SQL Commands
6.4. Data Manipulation
References
Chapter 7 Database Connectivity and Web Technologies
7.1. Introduction
7.2. Database Connectivity
7.3. Internet Databases
7.4. Extensible Markup Language
References
Chapter 8 Database Administration and Security
8.1. Introduction
8.2. The Role of a Database in an Organization
8.3. Introduction of a Database
8.4. The Evolution of Database Administration Function
References
Index
Back Cover
