Ebook Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (3rd Edition), by Michael J. Hernandez
Imagine that you get such specific amazing experience and also knowledge by just reviewing an e-book Database Design For Mere Mortals: A Hands-On Guide To Relational Database Design (3rd Edition), By Michael J. Hernandez. Exactly how can? It appears to be higher when a publication could be the ideal point to find. Publications now will show up in published and also soft file collection. One of them is this e-book Database Design For Mere Mortals: A Hands-On Guide To Relational Database Design (3rd Edition), By Michael J. Hernandez It is so common with the printed publications. Nonetheless, lots of people in some cases have no space to bring guide for them; this is why they can not review the e-book anywhere they really want.
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (3rd Edition), by Michael J. Hernandez
Ebook Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (3rd Edition), by Michael J. Hernandez
Excellent Database Design For Mere Mortals: A Hands-On Guide To Relational Database Design (3rd Edition), By Michael J. Hernandez publication is constantly being the most effective good friend for investing little time in your workplace, night time, bus, as well as almost everywhere. It will be an excellent way to merely look, open, and also review the book Database Design For Mere Mortals: A Hands-On Guide To Relational Database Design (3rd Edition), By Michael J. Hernandez while in that time. As understood, encounter as well as ability do not consistently had the much money to obtain them. Reading this publication with the title Database Design For Mere Mortals: A Hands-On Guide To Relational Database Design (3rd Edition), By Michael J. Hernandez will allow you know a lot more points.
It is not secret when hooking up the composing skills to reading. Reviewing Database Design For Mere Mortals: A Hands-On Guide To Relational Database Design (3rd Edition), By Michael J. Hernandez will make you obtain more sources and resources. It is a way that could improve how you ignore as well as understand the life. By reading this Database Design For Mere Mortals: A Hands-On Guide To Relational Database Design (3rd Edition), By Michael J. Hernandez, you can more than just what you get from other book Database Design For Mere Mortals: A Hands-On Guide To Relational Database Design (3rd Edition), By Michael J. Hernandez This is a prominent publication that is released from famous author. Seen type the author, it can be relied on that this book Database Design For Mere Mortals: A Hands-On Guide To Relational Database Design (3rd Edition), By Michael J. Hernandez will certainly offer several motivations, concerning the life as well as experience and everything inside.
You could not have to be uncertainty regarding this Database Design For Mere Mortals: A Hands-On Guide To Relational Database Design (3rd Edition), By Michael J. Hernandez It is simple method to get this publication Database Design For Mere Mortals: A Hands-On Guide To Relational Database Design (3rd Edition), By Michael J. Hernandez You could simply check out the established with the web link that we offer. Right here, you could buy guide Database Design For Mere Mortals: A Hands-On Guide To Relational Database Design (3rd Edition), By Michael J. Hernandez by on-line. By downloading Database Design For Mere Mortals: A Hands-On Guide To Relational Database Design (3rd Edition), By Michael J. Hernandez, you can locate the soft documents of this publication. This is the local time for you to begin reading. Also this is not printed publication Database Design For Mere Mortals: A Hands-On Guide To Relational Database Design (3rd Edition), By Michael J. Hernandez; it will exactly provide even more advantages. Why? You might not bring the published publication Database Design For Mere Mortals: A Hands-On Guide To Relational Database Design (3rd Edition), By Michael J. Hernandez or only pile guide in your property or the office.
You can finely include the soft data Database Design For Mere Mortals: A Hands-On Guide To Relational Database Design (3rd Edition), By Michael J. Hernandez to the gadget or every computer hardware in your workplace or house. It will certainly assist you to consistently continue reviewing Database Design For Mere Mortals: A Hands-On Guide To Relational Database Design (3rd Edition), By Michael J. Hernandez every single time you have spare time. This is why, reading this Database Design For Mere Mortals: A Hands-On Guide To Relational Database Design (3rd Edition), By Michael J. Hernandez doesn't provide you troubles. It will certainly offer you essential sources for you that intend to start composing, blogging about the comparable book Database Design For Mere Mortals: A Hands-On Guide To Relational Database Design (3rd Edition), By Michael J. Hernandez are different book field.
�
The #1 Easy, Commonsense Guide to Database Design! Michael J. Hernandez’s best-selling Database Design for Mere Mortals� has earned worldwide respect as the clearest, simplest way to learn relational database design. Now, he’s made this hands-on, software-independent tutorial even easier, while ensuring that his design methodology is still relevant to the latest databases, applications, and best practices. Step by step, Database Design for Mere Mortals � , Third Edition, shows you how to design databases that are soundly structured, reliable, and flexible, even in modern web applications. Hernandez guides you through everything from database planning to defining tables, fields, keys, table relationships, business rules, and views. You’ll learn practical ways to improve data integrity, how to avoid common mistakes, and when to break the rules.
�
Coverage includes
Understanding database types, models, and design terminology
Discovering what good database design can do for you—and why bad design can make your life miserable
Setting objectives for your database, and transforming those objectives into real designs
Analyzing a current database so you can identify ways to improve it
Establishing table structures and relationships, assigning primary keys, setting field specifications, and setting up views
Ensuring the appropriate level of data integrity for each application
Identifying and establishing business rules
Whatever relational database systems you use, Hernandez will help you design databases that are robust and trustworthy. Never designed a database before? Settling for inadequate generic designs? Running existing databases that need improvement? Start here.
- Sales Rank: #31128 in Books
- Published on: 2013-02-24
- Original language: English
- Number of items: 1
- Dimensions: 8.80" h x 1.60" w x 7.40" l, 2.45 pounds
- Binding: Paperback
- 672 pages
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).
Most helpful customer reviews
61 of 65 people found the following review helpful.
Interestingly different method for relational design
By Ybull
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.
Best Relational Database Design Book on the market!
By Shane Willerton
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.
The perfect introduction for a beginner.
By A fan of books
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.
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (3rd Edition), by Michael J. Hernandez PDF
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (3rd Edition), by Michael J. Hernandez EPub
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (3rd Edition), by Michael J. Hernandez Doc
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (3rd Edition), by Michael J. Hernandez iBooks
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (3rd Edition), by Michael J. Hernandez rtf
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (3rd Edition), by Michael J. Hernandez Mobipocket
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (3rd Edition), by Michael J. Hernandez Kindle
![[ The Olympus Device: Book Two Nobody, Joe ( Author ) ] { Paperback } 2014, by Joe Nobody](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_v3yrEBavB9xcF4KvwsAIGF3IjScKXfnPtPAANTgVHs_v51tjf7K2yvz6EKSm0CILSU2N8wDvzNmG6aZuzxMVQPmx9ZPxskPeWnif9WG7Y0TNxlIML2nE1L=s0-d "[ The Olympus Device: Book Two Nobody, Joe ( Author ) ] { Paperback } 2014, by Joe Nobody")
![[ The Olympus Device: Book Two Nobody, Joe ( Author ) ] { Paperback } 2014, by Joe Nobody](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_vynfbmQRDQg72KQooU_WnETZL8jJ9FpDeasEArecm_VJWLMOD3hjryPdzz_-2crxsPmlVrfuzodEQ2NWs5ZETvYhTDFkg=s0-d "[ The Olympus Device: Book Two Nobody, Joe ( Author ) ] { Paperback } 2014, by Joe Nobody")
