Data Modeling Essentials, Third Edition (Morgan Kaufmann Series in Data Management Systems) (The Morgan Kaufmann Series in Data Management Systems)

Refactoring Databases : Evolutionary Database Design (Addison Wesley Signature Series)

SQL Cookbook (Cookbooks (O'Reilly))

Database Design

Database Modeling and Design: Logical Design, 4th Edition (The Morgan Kaufmann Series in Data Management Systems)

Format: Paperback
Author: Toby J. Teorey
ReleaseDate: 06 September, 2005
Publisher: Morgan Kaufmann
Rating:

Just enough DB design without being complicated
It does a good job at explaining the basics of relational database models and how they fit into a modern business architecture. This book is now next to my desk as a reference text. The authors obviously have a methodology that works for them and the chapters seem to be organized according to their methodology. They start with UML, analyze the model in UML for potential problems, then move into SQL, normalization at the SQL stage, and end with an example. It's nicely written and concise.

-Frank Cohen
http://www. xquerynow. com
http://www. pushtotest. com.

Excellent introduction to data modeling
I've used this book since its first edition as my main reference on basic data modeling, and I have been happy to comment on its newer editions. I also am a reviewer of the book and an interested colleague. This 4th edition improves on earlier ones by including the Unified Modeling Language (UML), my own first choice for a design language for data modeling. The chapter on the UML includes everything you need, but it keeps it as simple and straightforward as possible, making the material very accessible. The real contribution of the book is in the normalization chapter and in the excellent description and examples of n-ary relationships and the consequences of their multiplicities, a very-hard-to-understand corner of the data modeling world. The inclusion in this edition of material on OLAP and data warehousing is also welcome, though very limited in scope. Finally, moving the physical design material into a separate book makes this book much more cohesive and useful as a reference for data modeling.

Excellent book for Data Modelers, etc.
. For those in Data Modeling, Data Architecture, and similar disciplines, I highly recommend this book ! An excellent discussion of database design and modeling, practices and techniques.