The Creation and Management of Database Systems

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. 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