Top positive review
Good book with some common-sense tips
Reviewed in the United States on May 5, 2014
First off, this book is well-written. Mr. Hernandez does a good job of explaining the "why" behind his explanations. He also provides tips that just seem to make sense. He advises that a table have a name that is plural, because each record is one "instance" of the data related to the table. As an example, a table called CarColors would have several rows, each containing one car color.
My only real criticisms are:
1. That he did not go enough into effectively indexing, applying primary/foreign keys, and applying constraints.
2. There was not enough discussion of the various "normalized" forms, when they should be used, and so forth. This is covered in a "flyover" manner that makes sense, but perhaps a more "in-depth" discussion of normalized forms is beyond the scope of the book.
I felt like I knew most of the information, but I didn't feel this book was a waste of money, as many of his "common sense" approaches I will utilize in my own DB designs in the future.