Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

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

4.1 out of 5 stars 8 customer reviews
ISBN-13: 978-0123820204
ISBN-10: 0123820200
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Sell yours for a Gift Card
We'll buy it for $9.46
Learn More
Trade in now
Have one to sell? Sell on Amazon
Rent On clicking this link, a new layer will be open
$15.85 On clicking this link, a new layer will be open
Buy used On clicking this link, a new layer will be open
$31.01 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$49.98 On clicking this link, a new layer will be open
More Buying Choices
32 New from $35.81 25 Used from $26.52
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Save Up to 90% on Textbooks Textbooks

Frequently Bought Together

  • Database Modeling and Design, Fifth Edition: Logical Design (The Morgan Kaufmann Series in Data Management Systems)
  • +
  • Database Systems: Design, Implementation, & Management
Total price: $245.24
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.

NO_CONTENT_IN_FEATURE


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: #420,916 in Books (See Top 100 in Books)

More About the Authors

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

Customer Reviews

Top Customer Reviews

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 7 of 8 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 7 of 10 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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.
Sorry, we failed to record your vote. Please try again
Report abuse
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.
Sorry, we failed to record your vote. Please try again
Report abuse

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: $49.98
Ships from and sold by Amazon.com

Want to discover more products? Check out these pages to see more: database design theory in books, data management theory, sam's data science, data modeling and database design