Beginning Database Design

From Novice to Professional

  • Authors
  • Clare Churcher

Table of contents

  1. Front Matter
    Pages i-xxv
  2. Clare Churcher
    Pages 1-8
  3. Clare Churcher
    Pages 9-24
  4. Clare Churcher
    Pages 25-42
  5. Clare Churcher
    Pages 43-58
  6. Clare Churcher
    Pages 59-74
  7. Clare Churcher
    Pages 75-91
  8. Clare Churcher
    Pages 93-112
  9. Clare Churcher
    Pages 113-127
  10. Clare Churcher
    Pages 129-140
  11. Clare Churcher
    Pages 141-155
  12. Clare Churcher
    Pages 157-168
  13. Clare Churcher
    Pages 169-188
  14. Back Matter
    Pages 189-225

About this book


Beginning Database Design, Second Edition provides short, easy-to-read explanations of how to get database design right the first time. This book offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers. Through the help of use cases and class diagrams modeled in the UML, you’ll learn to discover and represent the details and scope of any design problem you choose to attack.

Database design is not an exact science. Many are surprised to find that problems with their databases are caused by poor design rather than by difficulties in using the database management software. Beginning Database Design, Second Edition helps you ask and answer important questions about your data so you can understand the problem you are trying to solve and create a pragmatic design capturing the essentials while leaving the door open for refinements and extension at a later stage. Solid database design principles and examples help demonstrate the consequences of simplifications and pragmatic decisions. The rationale is to try to keep a design simple, but allow room for development as situations change or resources permit.

  • Provides solid design principles by which to avoid pitfalls and support changing needs
  • Includes numerous examples of good and bad design decisions and their consequences
  • Shows a modern method for documenting design using the Unified Modeling Language

Bibliographic information

Industry Sectors
Materials & Steel
Chemical Manufacturing
Finance, Business & Banking
IT & Software
Consumer Packaged Goods
Energy, Utilities & Environment