Buy New

or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
Buy Used
Used - Very Good See details
$25.61 & this item ships for FREE with Super Saver Shipping. Details

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
Have one to sell? Sell yours here
or
Get a $6.50 Amazon.com Gift Card
Database Modeling and Design: Logical Design, 4th Edition (The Morgan Kaufmann Series in Data Management Systems)
 
 

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

Toby J. Teorey (Author), Sam S. Lightstone (Author), Tom Nadeau (Author), H.V. Jagadish (Author)
4.5 out of 5 stars  See all reviews (8 customer reviews) Like (0)

List Price: $63.95
Price: $43.51 & this item ships for FREE with Super Saver Shipping. Details
You Save: $20.44 (32%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
Want it delivered Monday, March 21?
Order it in the next 11 hours and 59 minutes, and choose One-Day Shipping at checkout.
Details
28 new from $41.36 24 used from $19.99
Front Cover
Just so you know...

Your Browsing History
>
Customers Also Bought
Textbook Student FREE Two-Day Shipping for Students. Learn more

Formats

Amazon Price New from Used from
Kindle Edition $47.33  
Paperback $43.51  
Sell This Book Back for $6.50
Whether you buy it used on Amazon for $19.99 or somewhere else, you can sell it back to our Textbook Buyback Store at the current price of $6.50. Restrictions Apply
Used Price$19.99
Buyback Price$6.50
Price after
Buyback
$13.49
There is a newer edition of this item:
Database Modeling and Design, Fifth Edition: Logical Design (The Morgan Kaufmann Series in Data Management Systems) Database Modeling and Design, Fifth Edition: Logical Design (The Morgan Kaufmann Series in Data Management Systems)
$58.21
In Stock.
See a problem with this suggestion? Let us know

Frequently Bought Together

Customers buy this book with Learning SQL $26.39

Database Modeling and Design: Logical Design, 4th Edition (The Morgan Kaufmann Series in Data Management Systems) + Learning SQL
  • This item: Database Modeling and Design: Logical Design, 4th Edition (The Morgan Kaufmann Series in Data Management Systems)

  • Learning SQL


Customers Who Bought This Item Also Bought

  Page 1 of 25

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

Book Description

Extensively revised edition of the classic logical database design reference.

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.5 out of 5 stars  See all reviews (8 customer reviews)
  • Amazon Bestsellers Rank: #462,455 in Books (See Top 100 in Books)
  •  Would you like to update product info, give feedback on images, or tell us about a lower price?


 

Customer Reviews

8 Reviews
5 star:
 (6)
4 star:    (0)
3 star:
 (2)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
4.5 out of 5 stars (8 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

23 of 24 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)   
This review is from: Database Modeling and Design: Logical Design, 4th Edition (The Morgan Kaufmann Series in Data Management Systems) (Paperback)
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.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


13 of 14 people found the following review helpful:
5.0 out of 5 stars 4th edition of a classic book, January 21, 2006
This review is from: Database Modeling and Design: Logical Design, 4th Edition (The Morgan Kaufmann Series in Data Management Systems) (Paperback)
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.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


8 of 8 people found the following review helpful:
3.0 out of 5 stars A nice to read book, but not your unique one, June 13, 2009
By 
Filipuci Bruno (Belfaux, Fribourg, Switzerland) - See all my reviews
(REAL NAME)   
Amazon Verified Purchase(What's this?)
This review is from: Database Modeling and Design: Logical Design, 4th Edition (The Morgan Kaufmann Series in Data Management Systems) (Paperback)
This book can be considered as having been structured in four distinct parts.

First part, the introductory one, is made of three chapters starting with the description of the Database Lifecycle, from Requirements Analysis to Physical Design. Then, follow the Entity-Relationship Modeling and the UML chapters in which the reader is presented ER constructs and basic UML notation used in the following chapters.

Second part is about the core of the book: Data Modeling. Requirements Analysis and Conceptual Modeling are addressed in chapter 4.
Next chapter is about transforming the Conceptual Data Model to SQL and contains a very useful set of figures that summarize how different relationship types, i.e. one-to-one, one-to-many, many-to-many, are translated into sets of SQL table creation constructs, including primary and foreign key attributes. This chapter alone may be worth the price of this book.
Chapter 6 addresses Normalization. Expectedly, First, Second, Third and Boyce-Codd Normal Forms are explained here, without resorting to too much theory. Things are different, however, for the Fourth and Fifth Normal Forms, as a good understanding of MVD - Multivalued Dependency - and of related rules and axioms are needed to grasp what 4NF and 5NF really mean. These are the most theoretical 10 pages or so of this book.
In the last chapter of this part, there is "An example of Logical Database Design"; an insignificant chapter of a few pages long, based on a very simplistic implementation of the all-too-common "Retail Store" problem that barely translates into 8 SQL table creation construct sets.

Third part, chapter 8, is about Business Intelligence. It covers Data Warehousing, OLAP and Data Mining. It is unclear to me why the authors chose to spend - should I say waste - 40 pages on a 200 plus page book addressing OLAP-specific data modeling, that is in many aspects in opposition with OLTP-specific data modeling principles - denormalized vs. normalized tables, star schema vs. ER diagrams - that the authors addressed, developed and promoted in the first 145 pages of the book.

Fourth and last part addresses CASE Tools for Logical Database Design. Although useful and interesting, we have here 25 pages prone to quick obsolescence because somewhat product-specific.

This book does not address the handling of business rules and of time-dependent data, although common in real-life databases.

Overall, this is a nice to read introductory book, but certainly not your unique book if you expect to be able to perform serious database modeling. The statement on back cover "... get plenty to help you grow from a new database designer to an experienced designer developing industrial-sized systems" seems a bit presumptuous.

My suggestion to the authors: Drop chapter 8 and write another book on OLAP-specific data modeling; rewrite chapter 7 by referring to a more realistic and consistent case example; address handling of business rules and time-dependent data.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews






Only search this product's reviews



Customers Also Bought Items By

loading

Inside This Book (learn more)




Customers Viewing This Page May Be Interested in These Sponsored Links

  (What's this?)
     Free ERwin Trial opens new browser window
  www.sandhill.co.uk   -   Try the market-leading data modeling and database design tool
     Visual Data Modeling Tool opens new browser window
  www.datanamic.com/dezign   -   Design, visualize (ERD) or document your database with DeZign for DB.
     Data Modeling opens new browser window
  pervasiveintegration.com   -   Define & analyze data requirements to support your business process
See a problem with these advertisements? Let us know

What Do Customers Ultimately Buy After Viewing This Item?

Database Modeling and Design: Logical Design, 4th Edition (The Morgan Kaufmann Series in Data Management Systems)
70% buy the item featured on this page:
Database Modeling and Design: Logical Design, 4th Edition (The Morgan Kaufmann Series in Data Management Systems) 4.5 out of 5 stars (8)
$43.51
Beginning Database Design: From Novice to Professional
8% buy
Beginning Database Design: From Novice to Professional 4.3 out of 5 stars (24)
$21.77
Data Modeling Made Simple: A Practical Guide for Business and IT Professionals, 2nd Edition
8% buy
Data Modeling Made Simple: A Practical Guide for Business and IT Professionals, 2nd Edition 5.0 out of 5 stars (6)
$44.95
Learning SQL
7% buy
Learning SQL 4.3 out of 5 stars (37)
$26.39

Tag this product

 (What's this?)
Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items.
 

Customer Discussions


Listmania!


So You'd Like to...



Look for Similar Items by Category


Look for Similar Items by Subject

 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info, give feedback on images, or tell us about a lower price?
Is there any other feedback you would like to provide? Click here

Your Recent History

 (What's this?)