- Paperback: 480 pages
- Publisher: Addison Wesley; 1 edition (19 Dec. 1996)
- Language: English
- ISBN-10: 0201694719
- ISBN-13: 978-0201694710
- Product Dimensions: 2.5 x 19 x 23.5 cm
- Average Customer Review: 4.0 out of 5 stars See all reviews (49 customer reviews)
Amazon Bestsellers Rank:
832,016 in Books (See Top 100 in Books)
- #180 in Books > Computers & Internet > Computer Science > Databases > Database Design & Theory
- #183 in Books > Computers & Internet > Computer Science > Databases > Beginners & Introduction
- #818 in Books > Computers & Internet > Computer Science > Databases > Data Storage & Management > Database Management Systems
- See Complete Table of Contents
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design Paperback – 19 Dec 1996
There is a newer edition of this item:
Customers Who Viewed This Item Also Viewed
Enter your mobile number or email address 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.
To get the free app, enter your e-mail address or mobile phone number.
More About the Author
Database Design for Mere Mortals: A Hands-on Guide to Relational Database Design, Second Edition lets us know from the off that programmers and software architects don't really make a conscious decision to design an application (particularly one with online exposure) around the three-tier model-view-controller design pattern anymore. Three-tier, largely because of its adaptability and stability, is the norm. All of which means you need a database to underpin each of your applications. Designing your databases correctly can make the difference between slow-running, complicated code and software that's speedy, modular and easy to work with. Database Design for Mere Mortals prepares someone with only a passing familiarity with databases for the important job of building the persistence layer (also called the data model) for software.
Michael Hernandez explains database design in tradesman's terms. That is, he shows his readers how to identify the business problems that have to be satisfied by a database, then proceeds to explain how to build a solid solution to them. Hernandez's approach combines procedural guidelines (first identify critical facts, then apply a certain logic to yield tables, then establish cross-references, and so on) with practical definitions that clear up much of the rich trove of jargon surrounding databases. He walks through numerous examples, and doesn't shy away from the complexities that always exist in real customers' requirements. If you're not familiar with database design, and want to be, this is the book you need.
Topics covered: how to design databases that fit business requirements and make software construction easier. In addition to explaining relational database concepts, the author explains data integrity, null values, keys, table relationships (one-to-one, one-to-many, and many-to-many) and data types. He emphasises processes designers should follow in building a new database or improving an existing one. --David Wall, Amazon.com
From the Back Cover
Sound design can save you hours of development time before you write a single line of code. Based on the author's years of experience teaching this material, Database Design for Mere Mortals is a straightforward, platform-independent tutorial on the basic principles of relational database design.
Database design expert Michael J. Hernandez introduces the core concepts of design theory and method without the technical jargon. Database Design for Mere Mortals will provide any developer with a common-sense design methodology for developing databases that work.
What Other Items Do Customers Buy After Viewing This Item?
Top Customer Reviews
If you are confused and want a easy-to-read book to get started, choose this book and you'll be well on your way.
I quickly grew tired of spending my days on the phones with telcos trying to find out why my frames were down, so I decided to change paths.
I started developing small databases with Access and decided to pursue more robust applications powered by MS SQL Server. I didn't have a problem with Transact SQL or with the mathematics behind the relationships; however I did have a problem figuring out how to begin some sort of domain analysis.
I read the reviews of Mr. Hernandez's book this past weekend and went right down to Border's to purchase it (Sorry Amazon... I couldn't wait until Monday). It's the best investment I've made in books about relational databases!
Mr. Hernandez's approach will teach you how to plan your database so that you can implement it right the first time! If I had read this book 4 months ago, I could have saved myself many frustrating hours!
My partner and I are starting a new project around the first of the year with an incredibly aggressive timeline for deployment. I gave her the book this afternoon. We intend to apply many of the techniques discussed in the book to develop our plan for coding to go as smoothly as possible; and hopefully start making some money soon!
Writing your SQL statements is the easy part. Mr. Hernandez's book will help you streamline your planning phase, so that you can get your applications out of development and into production more efficiently.
Most Recent Customer Reviews
I am not kidding - back in the day when I used to knock up front end code for a living I was working at a place where I was told I had to design a database to support the sales... Read morePublished on 1 Mar. 2012 by Karl
This book is brilliant. It's clearly written, has loads of information and is the ideal primer for anyone starting to study relational databases. Read morePublished on 29 July 2001
Attractive title, attractive cover, attractive writing style, but I haven't found the meat yet. This one holds the attractive prospect of not losing me in technical jargon, but... Read morePublished on 6 Dec. 1999
Although it follows a different approach to designing a database than I teach, it is a required reading for my classes. The only thing missing is recursive relationships.Published on 4 Aug. 1999
This book methodically outlines the process of designing an efficient, scalable database. The fundamental premise of this book is that HOW YOU STRUCTURE YOUR DATA affects the... Read morePublished on 19 July 1999
I purchased this text as an introduction to relational database design concepts with emphasis on practical knowledge and less theory. Read morePublished on 26 Jun. 1999
I'm tired of waiting for the library's one copy to come back. It IS smart to know what the end users want to see - they are the ones you are designing it for! Read morePublished on 23 Jun. 1999