Database Design [Paperback]

Ryan Stephens (Author), Ronald Plew (Author)

Book Description

ISBN-10: 0672317583 | ISBN-13: 978-0672317583 | Publication Date: November 30, 2000 | Edition: 1

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.

Editorial Reviews

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.

From the Back Cover

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.

See all Editorial Reviews

Product Details

• Paperback: 528 pages
• Publisher: Sams; 1 edition (November 30, 2000)
• Language: English
• ISBN-10: 0672317583
• ISBN-13: 978-0672317583
• Product Dimensions: 9.1 x 7.4 x 1.2 inches
• Shipping Weight: 2 pounds (View shipping rates and policies)
• Average Customer Review: 4.6 out of 5 stars  See all reviews (5 customer reviews)
• Amazon Best Sellers Rank: #615,949 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

6 of 6 people found the following review helpful:

5.0 out of 5 stars Very Good - I will reference this often, August 31, 2007

By 

Robert F. Castellow "merchant of arbroath" (Decatur, GA) - See all my reviews
(REAL NAME)   

This review is from: Database Design (Paperback)

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 :)

2 of 2 people found the following review helpful:

5.0 out of 5 stars Excellent textbook, October 30, 2009

By 

Dennis J. Mcguckian (Los Angeles, CA United States) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Database Design (Paperback)

I used this as one of 2 textbooks to teach an Advanced SQL Database class and though it was very thorough and well laid out

1 of 1 people found the following review helpful:

5.0 out of 5 stars GREAT!, June 11, 2009

By 

S. Friedman (Detroit, MI) - See all my reviews
(REAL NAME)   

This review is from: Database Design (Paperback)

I bought this book to learn some more formal concepts of database design; for work. It is an excellent book, definitely buy this.