Beginning Database Design

1. Front Matter

   Pages i-xxv

   PDF

2. What Can Go Wrong

   • Clare Churcher

   Pages 1-8

3. Guided Tour of the Development Process

   • Clare Churcher

   Pages 9-24

4. Initial Requirements and Use Cases

   • Clare Churcher

   Pages 25-42

5. Learning from the Data Model

   • Clare Churcher

   Pages 43-58

6. Developing a Data Model

   • Clare Churcher

   Pages 59-74

7. Generalization and Specialization

   • Clare Churcher

   Pages 75-91

8. From Data Model to Relational Database Design

   • Clare Churcher

   Pages 93-112

9. Normalization

   • Clare Churcher

   Pages 113-127

10. More on Keys and Constraints

    • Clare Churcher

    Pages 129-140

11. Query Basics

    • Clare Churcher

    Pages 141-155

12. User Interface

    • Clare Churcher

    Pages 157-168

13. Other Implementations

    • Clare Churcher

    Pages 169-188

14. Back Matter

    Pages 189-225

    PDF

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

Clare Churcher is currently a senior lecturer in the Department of Applied Computing at Lincoln University, New Zealand. She holds a degree in physics with first class honors and completed a Ph.D in physics at the University of Canterbury, New Zealand. She has done postdoctoral research in the Cavendish Laboratory at the University of Cambridge, England. Clare s research interests are in the management and visualization of data especially for scientific research. She has a background in database design, and has taught programming, analysis and design of information systems, and database management at undergraduate level, as well as software engineering and scientific visualization at post graduate level.

Policies and ethics