Cover image for Relational Database Design and Implementation, 3rd Edition

Relational Database Design and Implementation, 3rd Edition

Author Jan L. Harrington
Release Date: 2009/09/01
ISBN: 9780123747303
Topic:
0%
30
Chapters
0-1
Hours read
0k
Total Words
    Start Reading Now    
       Add to Wishlist       
View table of contents

Book Description

Fully revised, updated, and expanded, Relational Database Design and Implementation, Third Edition is the most lucid and effective introduction to the subject available for IT/IS professionals interested in honing their skills in database design, implementation, and administration. This book provides the conceptual and practical information necessary to develop a design and management scheme that ensures data accuracy and user satisfaction while optimizing performance, regardless of experience level or choice of DBMS.
The book begins by reviewing basic concepts of databases and database design, then briefly reviews the SQL one would use to create databases. Topics such as the relational data model, normalization, data entities and Codd's Rules (and why they are important) are covered clearly and concisely but without resorting to "Dummies"-style talking down to the reader.
Supporting the book's step-by-step instruction are three NEW case studies illustrating database planning, analysis, design, and management practices. In addition to these real-world examples, which include object-relational design techniques, an entirely NEW section consisting of three chapters is devoted to database implementation and management issues.


* Principles needed to understand the basis of good relational database design and implementation practices.
* Examples to illustrate core concepts for enhanced comprehension and to put the book's practical instruction to work.
* Methods for tailoring DB design to the environment in which the database will run and the uses to which it will be put.
* Design approaches that ensure data accuracy and consistency.
* Examples of how design can inhibit or boost database application performance.
* Object-relational design techniques, benefits, and examples.
* Instructions on how to choose and use a normalization technique.
* Guidelines for understanding and applying Codd's rules.
* Tools to implement a relational design using SQL.
* Techniques for using CASE tools for database design.

Table of Contents

  1. Cover image
  2. Table of Contents
  3. Copyright Page
  4. Preface to the Third Edition
  5. Acknowledgments
  6. Introduction
  7. Chapter 1. The Database Environment
  8. Chapter 2. Systems Analysis and Database Requirements
  9. Database Design Theory
  10. Chapter 3. Why Good Design Matters
  11. Chapter 4. Entities and Relationships
  12. Chapter 5. The Relational Data Model
  13. Chapter 6. Normalization
  14. Chapter 7. Database Structure and Performance Tuning
  15. Chapter 8. Codd's Rules for Relational Database Design
  16. Chapter 9. Using SQL to Implement a Relational Design
  17. Chapter 10. Using CASE Tools for Database Design
  18. Chapter 11. Database Design Case Study 1
  19. Chapter 12. Database Design Case Study 2
  20. Relational Design Practice
  21. Chapter 13. Database Design Case Study 3
  22. Database Implementation Issues
  23. Chapter 14. Concurrency Control
  24. Chapter 15. Database Security
  25. Chapter 16. Data Warehousing
  26. Chapter 17. Data Quality
  27. Chapter 18. XML
  28. Appendix. Historical Antecedents
  29. Glossary
  30. Index