Database Design for Mere Mortals®: A Hands-On Guide to Relational Database Design Paperback – Dec 19 1996
There is a newer edition of this item:
No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
To get the free app, enter your e-mail address or mobile phone number.
Relational databases are powerful tools for organizing data, but learning to use them effectively can be painful. Relational Database Design for Mere Mortals explains the concepts of relational-database design in an easy-to-digest fashion that covers both the theoretical underpinnings and their practical implications. Hernandez covers all the basics--table and field structure, keys, relationships, business rules, and more--but always keeps his feet on the ground with advice for real-world implementations and a particularly strong section on analyzing your current database infrastructure.
From Library Journal
This truly excellent introduction to relational database design will work for both novices and advanced designers because the book does not tie itself to any particular database implementation. Hernandez has years of database design and training experience. For all levels from public to university libraries.
Copyright 1997 Reed Business Information, Inc.
Top Customer Reviews
I particularly liked the focus on designing on paper first, because this provides a great requirements document and the basis for a user manual! Hernandez teaches you how to talk to the stakeholders and determine what the database needs to represent. He has a method for transforming a user interview into table and field names.
The book is well-laid out with lots of examples, a typeset that's easy on the eyes, and extremely clear prose.
I can't imagine where I would be today if I hadn't bought this book a year ago. My employers paid much less for this book than any class I have taken, and yet this has had the largest impact on the way I develop. Database applications I created after reading the book have gotten lots of good feedback from users.
There were a few parts of the book that I thought could have been amplified. The use of "subset" tables was introduced, but lacked discussion on how to build joins between main and subset tables. Database business rules were introduced, but "application-oriented" business rules were not, and they might influence the database structure. I applaud his inclusion of documenting "views", but I would have appreciated a discussion of testing the results of a view. Finally, his "Final goodbye" to the company seems too optimistic ... often there are changes after the initial design. Still, all in all, a useful book!
This book does not deal with database design; for the most part, it deals with definitions and small details. For example, the author focuses on little things like what to name your tables and fields.
This book contains very little in the way of actual database design concepts. It uses so many pages to explain things which have nothing to do with actual database design. The information relating to design is very detail oriented with no conceptual framework to tie it all together. This leaves students with no idea of how the little pieces fit into the big picture.
Try designing a database on your own after reading this book and see how far you actually get. When (or even if) you complete this task, take the finished product to someone who truly knows database design and ask for comments and criticism. I think that you'll be surprised at how little you've actually learned from this book.
For this upcoming semester, I plan on using Inside Relational Databases (ISBN 1852334010). I hope that it will be a better book.
1) I didn't get a chance to teach this class again.
2) The students complained about this book and its companion book (SQL Queries for Mere Mortals)...
Most recent customer reviews
This book is adequate but not great as an introduction to designing databases. I agree with other reviewers that it's quite repetitive and goes to extremes on details like field... Read morePublished on Feb. 7 2003
This is the most helpful book I have ever read in sorting out the complexities of relational database design. Read morePublished on Dec 31 2002 by Carol Duning
THANK YOU, THANK YOU, THANK YOU!!!
I have read your book "Database Design for Mere Mortals" and found it to be absolutely gratifying. Read more
Michael J. Hernandez takes known, accepted database analysis and design methodology and turns it into step-by step techniques to design and develop a good relational database. Read morePublished on July 5 2002 by Sheila Carmichael
This book gets the reader to begin thinking about relationships and entities absent of implementation - which is a critical part of being a database designer. Read morePublished on July 1 2002 by C. Giancola
Too much background and emphasis on interviews and talking to everyone in the company before explaing how to put together a logical database. Read morePublished on Feb. 14 2002 by Jingleballs
I'm buying this book a second time because I lent it out one too many times to people at my last job. Read morePublished on Dec 11 2001 by Jim Martino
Look for similar items by category
- Books > Computers & Technology > Databases > Database Design
- Books > Computers & Technology > Databases > Relational Databases
- Books > Computers & Technology > Programming > Software Design, Testing & Engineering > Structured Design
- Books > Professional & Technical > Professional Science > Mathematics
- Books > Textbooks > Computer Science & Information Systems > Database Storage & Design