An Introduction to Data Base Design

Betty Joan Salzberg

• Publisher: Academic Press
• Year: 2014
• Print ISBN: 9780126168709
• eBook ISBN: 9781483270487
• Topic: Computer Science
• Subtopic: Computer Science General
• Index: Computer Science

An Introduction to Data Base Design provides an understanding of how data base management systems (DBMS) work to be able to use any available commercial DBMS intelligently. This book presents the principle of independence of physical and local organization. Organized into seven chapters, this book begins with an overview of normal form theory. This text then describes the three types of DBMS. Other chapters consider the difficulties in processing queries where the names of the files are not mentioned. This book discusses as well how to group data hierarchically, how to use a preorder tree traversal to represent the data, and how to convert a network organization to a hierarchical one. The final chapter deals with four essential issues in data base theory, namely, recovery, security, integrity, and concurrency. This book is a valuable resource for computer science students in the junior or senior year, and people in industry who are doing technical work using data bases.

Table of contents

• Front Cover
• An Introduction to Data Base Design
• Copyright Page
• Table of Contents
• Preface
• Acknowledgments
• Dedication
• Chapter 1. Introduction
• Chapter 2. Normal Form Design Theory
• Chapter 3. Relational Data Bases
• Chapter 4. Network Data Bases (CODASYL)
• Chapter 5. Hierarchical Data Bases (IMS)
• Chapter 6. Physical Organization
• Chapter 7. Integrity, Concurrency, Recovery and Security
• Appendix 1: A CASE STUDY
• Appendix 2: CONSTRUCT YOUR OWN RELATIONAL DATA BASE
• Appendix 3: CREATE A CODASYL DATA DEFINITION LANGUAGE COMPILER
• Appendix 4: RELATIONAL ALGEBRA AND RELATIONAL CALCULUS NOTATION
• Answers to Selected Exercises
• BIBLIOGRAPHY
• Index