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 this image

Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design Paperback – Dec 19 1996


Amazon Price New from Used from
Paperback
"Please retry"
CDN$ 26.78 CDN$ 0.77

Join Amazon Student in Canada


NO_CONTENT_IN_FEATURE

Product Details

  • Paperback: 480 pages
  • Publisher: Addison-Wesley Professional; 1 edition (Dec 19 1996)
  • Language: English
  • ISBN-10: 0201694719
  • ISBN-13: 978-0201694710
  • Product Dimensions: 23.2 x 18.8 x 3.4 cm
  • Shipping Weight: 1.1 Kg
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (88 customer reviews)
  • Amazon Bestsellers Rank: #489,200 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Customer Reviews

4.0 out of 5 stars
Share your thoughts with other customers

Most helpful customer reviews

2 of 2 people found the following review helpful By A Customer on May 19 2004
Format: Paperback
I have to temper my enthusiasm for this book with the perspective gained by reading the negative comments of those who seem to be, by and large, professional database developers, programming experts, and teachers. First, I just gotta say: "no offense, but geez, what a bunch of snotty know-it-alls!" Now that I have that off my chest, this book was manna from heaven for me! I am a newbie, I'm using Access, I'm trying to create a system for my workplace (without knowing what I'm doing, mind you!), and I learn best through a logical approach, reinforcement, and repitition. I actually enjoyed the experience of skipping some paragraphs thinking, "yeah, yeah, you said that already, I GOT it!" But I think even having that experience helps me learn by shoring up the information deposit in my head. If you're in my situation, and you like starting at the beginning and getting a solid foundation, AND if you're not a big whoopdie doo database mogul, you will love this book! BTW, this is not a book about Access or any particular brand of database software, but a book about FUNDAMENTALS of database design that is probably most appropriate for people who don't intend to make their living designing databases. I'd bet that's a lot of people.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
By A Customer on May 20 2004
Format: Paperback
After trying to figure it out on my own, buying 3 differend $50 books, reworking my database project a half-dozen different ways, losing sleep, pulling my hair out... I finally found what I needed in this book. I think it is especially helpful for me because I've done enough trial and error to be truly convinced that I cannot avoid paying attention to the basics. For the first time, I feel like I know what I'm doing, at the foundation level at least. This book is written in amazingly clear and precise language, with a brilliantly logical organization. It reinforces learning through a deliberate method: "first I'll tell you what I'm going to tell you, then I'll actually tell you it, then I'll tell you what I told you (then give you a case study and a quiz)." Awesome. SO HELPFUL!! I don't know when I've felt so grateful for a book. If you're new to Access, or want to learn a solid method for building the foundation and framework of a database, I can't recommend this book highly enough.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
By A Customer on Feb. 7 2003
Format: Paperback
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 specifications. I suppose if you know nothing about DB design this book is OK - but you'll need other books and lots of practice designing your own databases if you truly want to become proficient. A much better general intro book to databases and simple design is 'Inside Relational Databases' by Whitehorn & Marklyn. Novices should look at 'Absolute Beginner's Guide to Databases' by John V. Petersen first.
Once you've mastered those 2 books then get the best available book on DB design/modeling: 'Case*Method: Entity Relationship Modelling' by Richard Barker. It's excellent.
Two other options for university level/advanced modeling: 'Database Modeling & Design' by Toby J. Teorey and 'Data Modeling Essentials: Analysis, Design, and Innovation' by Graeme C. Simsion
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
Format: Paperback
This is the most helpful book I have ever read in sorting out the complexities of relational database design. Most books tell you how to use the software but not the basics of design. I was able to put together a fairly complex database - and my relationships work - just by using this book!
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
Format: Paperback
If a computer book can be life-changing, this one would be. I had been working with databases for some time, but had no formal training. Often, I didn't understand the terms flying around, although I understood the concepts. This book defined all those database terms from normalization to join tables. It revolutionized the way I design databases.
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.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
Format: Paperback
This book shines in the process of communicating between the people who need the database and the database designer. This book would be valuable to a business contracting to set up a database. By using down-to-earth ("mortal") terms, Hernandez makes clear the value of normalization, and his "ideal table" and "ideal field" guidelines are practical presentations of the often more theoretically presented normalization. By describing how to document a table and field descriptions, Hernandez provides documentation guidelines that are often overlooked in introductory works. It might be valuable to store the answers to his "Field specification worksheet" into a "metadata" database.
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!
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.

Product Images from Customers

Most recent customer reviews

Search


Feedback