Database Design is the book you need to master the fundamentals of relational database design in today's ever-evolving world of database technologies. This book takes an approach to database design to teach the reader how to reach into the inner depths of an organization to understand the business needs, data, and daily processes that will all blend together to formulate a successful database. Much emphasis is placed on logical design as it is imperative to understand the inner workings of an organization to produce the highest quality database, while proactively eliminating future problems that are not so easy for a beginner to foresee.

Additionally, topics such as change control, business rule integration, database security implementation, and legacy database redesign are covered in detail. Examples of SQL code are shown to portray implementation tasks of a relational database. Examples are compliant with ANSI standard.

Amazon.com Review
Database design and administration may be the last refuge of the true gurus, now that visual languages have made programming more accessible and network administration certifications have proliferated to the extent that they have. Database Design explains the process of building data-storage systems to people who may have hacked around in databases before, but have never really engineered one from the ground up. Though they both specialize in Oracle work as consultants, authors Ryan Stephens and Ronald Plew remain mostly independent of implementation specifics here, focusing instead on generic relationship diagrams that illustrate structure and ANSI-standard structured query language (SQL) for code examples.

Revealing their consultancy roots, Stephens and Plew start with methods of determining business requirements and stay focused on business issues throughout their tutorials. The section on data normalization exemplifies the authors' method of explaining technical issues: they present a considerable amount of prose on why normalization (the process by which "Steve Jones," in entered data, is recognized as the same person as "Stephen P. Jones" where it is appropriate to do so) is a good idea, as well as some of its drawbacks and alternatives. They then present a series of table schema that shows how normalization works in practice. It's a worthwhile read for working and soon-to-be-working database designers. --David Wall

Topics covered: Database design for people who haven't designed databases before or who have done so without the background knowledge they should have had. The authors cover business requirements, entities and relationships, normalization, integrity maintenance, and query design. There are also sections on modifying legacy databases and implementing ancillary features such as security.

CUSTOMER REVIEWS (Average Customer Rating: 4.5 based on 3 reviews)

dry and methodical but highly relevant

I don't think I ever could have read this book when I was just beginning with database design. This is not because it's overly complex, but because the writing is excruciatingly dry and methodical. Having said that, and having had a few years of database programming, I now wish I had read this much sooner. Like many other self-taught programmers, I eventually realized that discipline, patience, and attention to a methodical process actually save time and are far more valuable traits for a database programmer than sheer intuition. For example, if you weren't thorough in gathering requirements, you're going to have to make up for this by repeating interviews during logical modeling. If you weren't thorough in physical modeling, well, re-engineering an existing database full of data is no small task.

A lot of the writing here is purely definitional (business rules, ERDs and process models, join types), and the concepts probably won't sink in until you sink your teeth in and actually do the work. However, the value of this book for someone with some working knowledge of database design is that it 1) provides you with a standard language that will help you communicate with other programmers, 2) will help fill in gaps in your knowledge, and 3) provides you with a series of checklists for each stage of the process (such as interviewing customers) to help ensure that you design databases more methodically and don't leave out any key steps. These concepts are so universally applicable in database programming that it really doesn't matter that this book is several years old. It's still relevant.

May 10, 2008

Very Good - I will reference this often

Recently, I worked with a few developers who were tasked with developing their own database, and soon realized that many developers are not disciplined database designers (myself included). Instead of struggling through ambiguous database designs and creating more work in the coding of business objects, I picked up a book. Database Design, by Ryan K. Stephens and Ronald R. Plew, provided a great foundation for me, and would probably be a good reference for many levels of developers, business analysts, and DBAs.

The book starts with an overview of the database design process. At times this section seemed basic for someone that has been through countless development cycles, but the section reiterates concepts that many may take for granted. For instance, the database design process of requirements gathering, logical modeling, and normalization is discussed. Also, from an academic perspective some history and non-traditional methods are reviewed that provide interesting contrasts to how the process of database design has evolved over time.

The second section begins to get into the technical meat. The second section discusses gathering business and system requirements. This also provides many good examples of how to translate the business model into database entities. The different forms of normalization are discussed with examples from the first, second, third, Boyce-Codd, fourth, and fifth normal forms. The authors also take the readers through the process of developing Entity Relationship Diagrams (ERDs) and uses accompanying examples.

The third section takes the concepts that are used from part two to design tables within the database. Consideration of storage, referential integrity, ownership, performance is all discussed as part of the physical design process. The authors also discuss enforcing business rules and view designs as well. The final chapter of this section ends in a real world scenario of a grocery store owner that wants to model his business activities into a live database. The book provides step by step re-iteration of the process involved in collecting business requirements, modeling data, normalization, and design. The author walks the reader through the process and shows how a designer would create a database from the information provided by the business owner. I thought this was a great example of how the books brought together concepts into real world situations. Kudos for the authors including some non-academic material.

Last, the authors discuss other areas that affect the database after the initial design. These areas include security, change control, analyzing legacy data. Each area includes examples and scenarios a DBA might encounter.

Overall, I thought this book laid down the foundations for database design very well. I think the authors had some very specific real world experiences that seemed useful during the discussions of the design process. The only con of this book was brief discussions about toolsets being used. It seemed apparent after a few of these examples that the authors are used to working in high budget software shops. Also, some of the tools may have been a bit outdated (2001). No mention of open source options was given which was a bit disappointing for someone who uses and develops open source products regularly (yes I am biased). The cons however, seemed minor in the big picture. This book lays down the framework for good process and also is very practical in its examples of the nuts and bolts of the database design process. I will definitely keep this somewhere close on my shelf, and do not expect the design aspects of the book to become outdated anytime soon. I think the authors did a great job at providing a good reference book on database design. I only wish more developers would read it :)
August 31, 2007

Excellent intro to DB Design

After thumbing through a half-dozen books on data modelling and database design, I finally picked up this book. It is the best intro to data modelling that I've come across yet. I've been playing with Oracle and MySQL for a year or so, but I knew I wasn't going to get very far if I didn't know how to build databases from scratch. This book was the first one I've come across that didn't take on the airs of an academic dissertation. Highly recommended for people who want to build Database Analyst skills.
January 23, 2001

SIMILAR PRODUCTS

Information Management For Health Care Professions (The Health Information Management Series)
by Merida Johns

Database Design for Mere Mortals(R): A Hands-On Guide to Relational Database Design (2nd Edition) (For Mere Mortals)
by Michael J. Hernandez

Electronic Health Records: A Practical Guide for Professional and Organizations, 3rd Edition
by MBA, RHIA, CHPS, CPHIT, CPEHR, FHIMSS Margret K. Amatayakul

High-Powered Teams: A Guide to Getting the Most Out of Your Student Team
by Merida Johns

New Perspectives on Microsoft Office Access 2003, Introductory, CourseCard Edition (New Perspectives (Paperback Course Technology))
by Joseph J. Adamski, Kathy T. Finnegan