Database Solutions : A step by step guide to building databases (2nd Edition)

Rating:
Summary: Really explains it well
Review: I liked this book from the start because it explains how to start up a database from scratch to finalization and with great detail. 426 pages of good information for the amateur or pro. Comes with a CD full of examples and sql scripts to use and two full length, coded example databases.

Rating:
Summary: Excellent Book!!
Review: The authors have probably done a favour to the database designer community with this book. Wonder why nobody thought about a book of this kind before. There are numerous books on generic DBMS but very few on Database Design. The book is equally useful for managers and developers. The examples are superb and have been thoughtfully presented and analysed.

Also the fact that the authors decided to use UML as the data modeling notation instead of traditional notations makes this book more "in tune with times" and "practically applicable" in a software development environment.

Rating:
Summary: Great teaching resource
Review: This book strikes just the right balance between theoretic rigour and practical examples/advice. The book defines an explicit, multi-step methodology, covering everything from requirements analysis, to logical modeling, to physical implementation, then shows how the methodology can be used in two involved, yet accessible, practice cases. The authors also sensibly show how this is implemented in common DBMSs (Access and Oracle).

If that wasn't worthwhile enough, the book contains two superb appendixes: one shows alternative modelling notations, the other provides diagrams and tables for 15 common data models. These in particular are an excellent idea -- I'm surprised more database design books don't provide them.

At any rate, this is the one database design book that I tend to recommend to my students. For students who are finding the formal computer science database design textbook too abstract, this book is a good counterweight; for students who need a single overview of database design, this book too is a great choice.