"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.