Database Design

Using client-proven methods and over 15 years of experience with the topic, Dr. Jones provides the reader with an understanding of the practical art of good database design, regardless of database type. Readers who have been confused by the high-end, academic style of current database design books will benefit from the approachable, tutorial style.

Frederic H. Jones, Ph.D., has been involved in database design and programming for fifteen years. He has designed and developed commercially available relational and object oriented database systems and applications, as well as database designs for clients such as GE, Westinghouse, Herman Miller Corporation, Lightolier, Moen, Carrier Corp and Electronic Arts. He is the founder of Eclat, Inc., a major database publisher in the construction industry and currently CEO of Learning Square, Inc. an Internet distance learning development and consulting firm.

Introduction

1

(9)

Part I Overview of Database Design

Understanding Database Fundamentals

9

(28)

Exploration of Database Models

37

(20)

Database Design Planning

57

(22)

The Database Design Life Cycle

79

(34)

Part II Analyzing and Modeling Business Requirements

Gathering Business and System Requirements

113

(36)

Establishing a Business Model

149

(12)

Understanding Entities and Relationships

161

(24)

Normalization: Eliminating Redundant Data

185

(24)

Entity Relationship Modeling

209

(26)

Modeling Business Processes

235

(24)

Part III Designing the Database

Designing Tables

259

(36)

Integrating Business Rules and Data Integrity

295

(24)

Designing Views

319

(26)

Applying Database Design Concepts

345

(38)

Part IV Life After Design

Implementing Database Security

383

(24)

Change Control

407

(20)

Analyzing Legacy Databases for Redesign

427

(64)

Appendixes

A Sample Physical Database Implementation

447

(16)

B Popular Database Design Tools

463

(2)

C Database Design Checklists

465

(10)

D Sample Database Designs

475

(12)

E Sample Table Sizing Worksheet

487

(4)

Glossary

491

(6)

Index

497

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Summary

Author Biography

Table of Contents

Supplemental Materials