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

~ (Author), Sam S. Lightstone (Author), Tom Nadeau (Author), H.V. Jagadish (Author) "Database technology has evolved rapidly in the three decades since the rise and eventual dominance of relational database systems..." (more)
Key Phrases: create table engineer, identifier empno, binary recursive relationship, Rational Data Architect, Computer Associates, Rational Division (more...)

Editorial Reviews

Review

"An explicit presentation on Business Intelligence is a major strength of this book. For beginners, there is an elegant presentation on SQL in the appendix and the book is supplemented by a detailed glossary. Exercises, examples and solutions constitute an important part of this book. This book is useful reading for both beginners and advanced users as the contents integrate elements that would address various audiences at different levels." - P. Pichappan, Department of Information Science, Annamalai University, India

Review

"An explicit presentation on Business Intelligence is a major strength of this book. For beginners, there is an elegant presentation on SQL in the appendix and the book is supplemented by a detailed glossary. Exercises, examples and solutions constitute an important part of this book. This book is useful reading for both beginners and advanced users as the contents integrate elements that would address various audiences at different levels."
- P. Pichappan, Department of Information Science, Annamalai University, India

See all Editorial Reviews

Product Details

• Paperback: 296 pages
• Publisher: Morgan Kaufmann; 4 edition (September 20, 2005)
• Language: English
• ISBN-10: 0126853525
• ISBN-13: 978-0126853520
• Product Dimensions: 9.1 x 7.4 x 0.7 inches
• Shipping Weight: 1.6 pounds (View shipping rates and policies)
• Average Customer Review: 4.1 out of 5 stars  See all reviews (9 customer reviews)
• Amazon.com Sales Rank: #540,783 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

21 of 22 people found the following review helpful:

5.0 out of 5 stars Excellent introduction to data modeling, January 23, 2006

By	Robert J. Muller (San Francisco, CA USA) - See all my reviews (REAL NAME)

I also am a reviewer of the book and an interested colleague. 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. 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.

13 of 14 people found the following review helpful:

5.0 out of 5 stars 4th edition of a classic book, January 21, 2006

By	Michael R. Blaha - See all my reviews (REAL NAME)

I am one of the reviewers for this book, but have no connection to the authors, other than being an impressed colleague.

This is a well-written, solid book by knowledgeable authors. Based on my consulting experience, many applications fall flat because of missing or inferior database conceptualization and design -- the subject of this book. The authors clearly explain how to build a database in terms of Entity-Relationship modeling. So if you think you could benefit from some advice, I recommend that you consider Teorey et al's new book.

10 of 11 people found the following review helpful:

5.0 out of 5 stars Just enough DB design without being complicated, June 14, 2006

By	Frank Cohen "-Frank Cohen" (Campbell, CA United States) - See all my reviews

This book is now next to my desk as a reference text. It does a good job at explaining the basics of relational database models and how they fit into a modern business architecture. 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