• RRP: £33.99
  • You Save: £8.22 (24%)
FREE Delivery in the UK.
Only 2 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Quantity:1
Database Design for Mere ... has been added to your Basket
+ £2.80 UK delivery
Used: Good | Details
Sold by UK Media Source
Condition: Used: Good
Comment: Ships SAME or NEXT business day. See our member profile for customer support contact info. We have an easy return policy.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 3 images

Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design Paperback – 14 Feb 2013

4.5 out of 5 stars 2 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
£25.77
£22.96 £19.02
Note: This item is eligible for click and collect. Details
Pick up your parcel at a time and place that suits you.
  • Choose from over 13,000 locations across the UK
  • Prime members get unlimited deliveries at no additional cost
How to order to an Amazon Pickup Location?
  1. Find your preferred location and add it to your address book
  2. Dispatch to this address when you check out
Learn more
£25.77 FREE Delivery in the UK. Only 2 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.
click to open popover

Special Offers and Product Promotions


Frequently Bought Together

  • Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design
  • +
  • SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL
  • +
  • SQL in 10 Minutes, Sams Teach Yourself
Total price: £63.44
Buy the selected items together

Enter your mobile number 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.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone

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




Product details

  • Paperback: 672 pages
  • Publisher: Addison Wesley; 3 edition (14 Feb. 2013)
  • Language: English
  • ISBN-10: 0321884493
  • ISBN-13: 978-0321884497
  • Product Dimensions: 18.8 x 4.1 x 22.4 cm
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 118,437 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

About the Author

Michael J. Hernandez, a relational database developer with more than twenty years of experience, was a program manager and product manager for Microsoft’s Visual Studio group. He has been a premier instructor with organizations such as AppDev Training Co., Focal Point, Inc., and Deep Training, and was a top-rated speaker at technical conferences across the United States, Europe, and South America. With John L. Viescas, he coauthored SQL Queries for Mere Mortals®, Second Edition (Addison-Wesley, 2008).


Customer Reviews

4.5 out of 5 stars
5 star
1
4 star
1
3 star
0
2 star
0
1 star
0
See both customer reviews
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback Verified Purchase
I read this book cover to cover. The author does a great job of writing a technical book in a non technical way. If you are begining database design then this book will give you a super process on how to create a good database design - its just up to you to follow the process.
Comment 6 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: Kindle Edition Verified Purchase
Interesting. Improved my understanding of databases.
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

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: HASH(0x9aa59120) out of 5 stars 48 reviews
61 of 65 people found the following review helpful
HASH(0x9b00ebf4) out of 5 stars Interestingly different method for relational design 3 Sept. 2013
By Ybull - Published on Amazon.com
Format: Paperback
I read this book while searching for different textbooks to use in the university database course I teach.

Hernandez' method and presentation of it are distinctly different from all other books I've read on database design. The author has developed a fairly thorough approach for designing relational databases without requiring the designer to delve into the traditional mathematical jargon and occasionally difficult concepts upon which relational theory is based.

Besides the easy understandability to a layman, it seems to me the biggest values in Hernandez' approach and the book is that it is well described as sequence of operations to do with short interviews of the various stakeholders in the database's intended environment. I learned to do similar interviews pretty well through years of experience but without having been taught a method.

Although the whole method appears valid, a few limitations and drawbacks of the book surfaced on my first reading:

* The method has so many steps it isn't likely that someone can memorize it all.
* Though not surprising from the subtitle, the design method here is inextricably tied to the relational model. (I had hoped that the approach would be more generalized and then show how to produce a valid relational model from a conceptual design. The latter is the way I've been teaching up to now so Hernandez' approach loses some flexibility.)
* It's laborious: The whole method is VERY heavy on filling out lengthy forms to document each table, field, view, etc. In theory this good, but it is done in a way that could easily require my students to record 50+ pages worth of forms for their main class project before they even start to implement anything. Designing some production database systems I deal with would have produced 2,000 pages of these forms. It might be possible to adapt the essence of these forms into a different layout that would be more efficient, and would really appreciate hearing comments about the voluminous forms from anyone who has used the method.
* In Chapter 10, the matrix method used for "Identifying Existing Relationships" is confusing and inefficient. Although the final results are valid, the intermediate notations make an improper and misleading unidirectional use of the 1:1 and 1:N cardinality notations. There are a couple of ways to correct this part of the method that I would use if I taught from it.
21 of 21 people found the following review helpful
HASH(0x9b00ec48) out of 5 stars Best Relational Database Design Book on the market! 17 Jun. 2013
By Shane Willerton - Published on Amazon.com
Format: Paperback
Excellent introduction to Relational Database Design. This is a complete methodology for designing databases from start to finish. Good refresher for experienced data modelers as well.

Database Design for Mere Mortals is the perfect introduction to relational database design for the novice and anyone needing a refresher. Straight forward examples and the absence of complex mathematical terms common with other books on the topic make this an easy, enjoyable and very practical read for anyone seeking to understand relational database design from an operational database perspective.

Disclaimer: I have to admit being biased towards this book. I read the first edition of Database for Mere Mortals when I was just starting my career in database application development 15 years ago and I have referred to it often over the years. Lacking a degree in Computer Science and Mathematics, I was daunted by the other books on the market at the time on Database Design Theory. However, when I came across this book, it launched my career in ways that I could not have predicted at the time.

Database Design for Mere Mortals is written is a straight-forward, easy to read format. The author clearly explains complex relational concepts without the use of difficult to understand mathematical jargon. The design process that the author lays out in this book is concise, yet complete for the purpose of properly designing a well-tuned operational database based on relational database technology. To get value out of this book requires no database experience nor a background in computer science or mathematics on the part of the reader. The author only briefly mentions the Normal Forms (the mathematical theory of relational database design) by name but the process that he lays out allows the reader to fully implement a database consistent with the Normal Forms without having to decipher their meaning.

Anyone starting out in either a Database development, design or analysis role will get a lot of value out of reading this book. I have recommended this book to everyone that has asked me how to get started in Databases for the last 15 years.
This book is not the only database design methodology in practice today. Analytical Reporting Databases typically use a dimensional modeling approach which the author kindly directs the user to in his further reading section. Even someone working with a non-operational database would benefit greatly from the techniques outlined in this book prior to applying dimensional modeling techniques.

My only disappointment with the 3rd Edition of Database Design for Mere Mortals is that I had hoped the author would have touched more upon the topics of Agile database development and database refactoring. The trend in the industry is to allow less time for formalized, quality design processes such as this one. Unfortunately, this trend usually sacrifices data integrity and sound design practices for rapid and flexible development.
12 of 12 people found the following review helpful
HASH(0x9aa0ed38) out of 5 stars The perfect introduction for a beginner. 17 April 2013
By A fan of books - Published on Amazon.com
Format: Paperback
I've used the previous edition of this book as the primary text for a college database design class for several years. I was so happy to see a new edition ready for the summer semester this year! The book is easy to incorporate into class lectures, and my students seem to enjoy it. The additional section on normalization in this edition is much appreciated.
11 of 11 people found the following review helpful
HASH(0x9b00eed0) out of 5 stars Good book with some common-sense tips 5 May 2014
By MJR - Published on Amazon.com
Format: Paperback Verified Purchase
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.
8 of 9 people found the following review helpful
HASH(0x9b00ee70) out of 5 stars A great start for beginners 29 April 2013
By R. Waymire - Published on Amazon.com
Format: Paperback
I just finished reading this new edition, and it looks like it continues to serve the purpose of the earlier editions. If you are new to data modeling, this is a great place to start. A properly designed database (both logically and physically) will make all the difference in the long run to maintainability, stability, and flexibility as business needs change. This book will give you the foundation to make this happen.
Were these reviews helpful? Let us know


Feedback