Industrial-Sized Deals Shop all Back to School Shop Women's Handbags Learn more nav_sap_SWP_6M_fly_beacon Deradoorian $5 Off Fire TV Stick Off to College Essentials Shop Popular Services pivdl pivdl pivdl  Amazon Echo Starting at $99 Kindle Voyage Nintendo Digital Games Gear Up for Football Deal of the Day
Buy New
$41.66
Qty:1
  • List Price: $64.95
  • Save: $23.29 (36%)
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Database Modeling and Des... has been added to your Cart
Sell yours for a Gift Card
We'll buy it for $21.42
Learn More
Trade in now
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Database Modeling and Design, Fifth Edition: Logical Design (The Morgan Kaufmann Series in Data Management Systems) Paperback – February 10, 2011

8 customer reviews
ISBN-13: 978-0123820204 ISBN-10: 0123820200 Edition: 5th

Buy New
Price: $41.66
33 New from $37.64 17 Used from $37.73
Rent from Amazon Price New from Used from
Kindle
"Please retry"
$16.15
Paperback
"Please retry"
$41.66
$37.64 $37.73
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


InterDesign Brand Store Awareness Textbooks

Frequently Bought Together

Database Modeling and Design, Fifth Edition: Logical Design (The Morgan Kaufmann Series in Data Management Systems) + Computer Organization and Design, Fifth Edition: The Hardware/Software Interface (The Morgan Kaufmann Series in Computer Architecture and Design)
Price for both: $115.84

Buy the selected items together

Editorial Reviews

Review

"Database Modeling and Design is one of the best books that I have seen for explaining how to build database applications. The book is informative, well-written, and concise."-Michael Blaha, DSc., Consultant, Modelsoft Consulting Corp

"This book book is by far the best book available on classic database design. Topics like normalization and many-to-many and n-ary association semantics are without peer in teaching you how to model real-world complexities. This latest edition extends the classic material with extensive discussion of modern tools and other aspects of logical database design. Every database architect should have this book at hand."-Bob Muller, Data Analyst, Poesys Associates

“The book is not only good for beginners, but it also provides greater insight for experienced learners. Perhaps this is why it has evolved into its fifth edition. The book is generally well organized. It starts with the first step in the database life cycle, and progresses in a chronological order to more advanced concepts such as object relational design, Extensible Markup Language (XML), and Web databases. The writing style of the book is simple and straightforward, and the use of database terminology is very concise…In my opinion, the book could be used as a course text, with some help from other sources to cover SQL query-related concepts. However, I would have liked a chapter on SQL that covered simple and complex query design, as well as optimization."-- Computing Reviews

From the Back Cover

Database systems and database design technology have seen significant changes in recent years. The relational data model and relational database systems dominate applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. Businesses are expanding and require well-constructed databases to track their new and various needs. How do you model and design your database application in the event of new technology or new business needs?

The answers are all in the fifth edition of Database Modeling and Design: Logical Design. This book shows you how to develop data modeling concepts and logical database design consistently over a wide scope in a way that will support the needs of your enterprise. Updated clear explanations, in-depth detail, real-world examples, and illustrative case studies provide you with practical advice that you can count on―with design rules that are applicable to any SQL-based system.

NEW to this edition:

*NEW- A whole chapter devoted to XML and web databases. What you need to know to utilize XML rather than relational tables.

*A whole chapter describing Object Relational Design. Learn how to make a choice between what is in the database as a BLOB and what is outside in a separate file.

See all Editorial Reviews
NO_CONTENT_IN_FEATURE
Best Books of the Month
Best Books of the Month
Want to know our Editors' picks for the best books of the month? Browse Best Books of the Month, featuring our favorite new books in more than a dozen categories.

Product Details

  • Series: The Morgan Kaufmann Series in Data Management Systems
  • Paperback: 352 pages
  • Publisher: Morgan Kaufmann; 5 edition (February 24, 2011)
  • Language: English
  • ISBN-10: 0123820200
  • ISBN-13: 978-0123820204
  • Product Dimensions: 7.5 x 0.8 x 9.2 inches
  • Shipping Weight: 1.6 pounds (View shipping rates and policies)
  • Average Customer Review: 4.1 out of 5 stars  See all reviews (8 customer reviews)
  • Amazon Best Sellers Rank: #887,910 in Books (See Top 100 in Books)

More About the Authors

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

Customer Reviews

Most Helpful Customer Reviews

6 of 7 people found the following review helpful By John W. Graham VINE VOICE on June 7, 2012
Format: Paperback Vine Customer Review of Free Product ( What's this? )
I have a Computer Science background and I have worked in various capacities ranging from software design and development to systems engineering and project management. I work on a lot of large scale software programs which rely on robust, properly designed relational database systems.

The authors start off with a very accurate statement in the introduction; knowing and understanding both data modeling and database design techniques and applying that knowledge to logical and physical database design are important knowledge assets.

The book starts with an introduction to ER diagrams which are frequently used in conceptual data modeling. Some sage advice is given in the "Tips and Insights for Database Professionals". The next chapter delves into UML, which I have seen used on every program I have worked on. Indeed, having a working knowledge of ER and UML diagrams helps convey your designs in a more-or-less standardized language format. Not all organizations embrace all types of UML diagrams, so a generalized knowledge is key, and this book only touches the surface of both UML and ER diagramming. I would recommend supplemental references for really getting into UML or ER diagramming.

The next chapter is on requirements analysis and conceptual data modeling. The authors contend that RA feeds conceptual data modeling using ER and UML diagrams, which I have found to be common. Moving along, there is a discussion on transforming the conceptual data model to SQL. This is a good high level introductory chapter. From this chapter, we move into normalization. Normalization is difficult and requires proper performance analysis.

Chapter 7 introduces an example of logical database design.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 10 people found the following review helpful By Kilgore Gagarin TOP 500 REVIEWER on June 30, 2011
Format: Paperback Vine Customer Review of Free Product ( What's this? )
I have to underscore a statement in the preface with which I am in total agreement: "This book can . . . be used by the advanced undergraduate or beginning graduate student to supplement a course textbook in introductory database management . . ." In fact, the authors point out that the fifth edition of this book has been split into a second work, PHYSICAL DATABASE DESIGN: THE DATABASE PROFESSIONAL'S GUIDE, 1st edition (a title that is not in print at the time of this review). As a book about "Logical Design," explaining WHY (not HOW) is the strength of the work. This is not a book one would primarily rely upon for developing an application. But it is an excellent work for giving solid background in the underpinnings of database design. The HOW (as the author's stated) is spawned off in another work, in this case.

I'm a non-professional IT person who has designed and implemented dozens of LAMP (Linux-Apache-MySQL-php) applications, and database design activities dating back to the 1980's, primarily in the honorable environment of the various MS-DOS flavors of the day. All of this with zero formal training (which isn't the same as NO training). With that background in mind, after going through this book I confirmed that I had picked up a lot of bad habits and developed a lot of good practices. My worst habit? A preference for flat databases over relational ones (see Chapter 8 - Object-Relational Design). My hardest earned (and confirmed by this book) good practice? The absolute importance of "requirements analysis," or, rigorous interviewing of the end user population to "determine exactly what the database is to be used for . . ." (see Chapter 4 - Requirements Analysis and Conceptual Data Modeling). In both of these cases this book was excellent in explaining WHY.
Read more ›
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback Vine Customer Review of Free Product ( What's this? )
.
This book is quite helpful if you already have a fair amount of experience with databases and you want to:

- learn to better optimize database structures
- learn the language of database design in order to better understand the literature and better communicate with other database professionals.

If you don't have much database experience already, or you don't have a driving interest in the subject, this book will be tough sledding. Things are not explained in a "database design for dummies" fashion. A lot of nutrition, but not much flavoring.

Check it out with "Look Inside"

Don't forget to check for used copies.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback
I bought this book for my Advanced Database Modeling class. Where I would have encountered problems in trying to set up all of the keys within large databases, this book make it very clear on how to set up my ideas on paper, and then implement them in SQL. This book does contain some reference material for learning SQL, but if you don't already know the basics of the language, you should find a beginner level book that is written for that purpose. That said, I think this book is a great reference for those new or experienced with Database Modeling.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Database Modeling and Design, Fifth Edition: Logical Design (The Morgan Kaufmann Series in Data Management Systems)
This item: Database Modeling and Design, Fifth Edition: Logical Design (The Morgan Kaufmann Series in Data Management Systems)
Price: $41.66
Ships from and sold by Amazon.com