Database design for mere mortals: a hands-on guide to by Michael J. Hernandez

By Michael J. Hernandez


The number one effortless, common sense consultant to Database layout! Michael J. Hernandez’s best-selling Database layout for Mere Mortals® has earned around the world recognize because the clearest, easiest method to benefit relational database layout. Now, he’s made this hands-on, software-independent instructional even more uncomplicated, whereas making sure that his layout technique continues to be proper to the newest databases, functions, and top practices. Step by way of step, Database layout for Mere Mortals ® , 3rd Edition, exhibits you the way to layout databases which are soundly dependent, trustworthy, and versatile, even in smooth internet purposes. Hernandez courses you thru every thing from database making plans to defining tables, fields, keys, desk relationships, enterprise ideas, and perspectives. You’ll research useful how one can enhance info integrity, tips to stay away from universal blunders, and whilst to wreck the rules.


Coverage includes

Understanding database varieties, types, and layout terminology

Discovering what solid database layout can do for you—and why undesirable layout could make your lifestyles miserable

Setting ambitions on your database, and remodeling these ambitions into genuine designs

Analyzing a present database so that you can establish how one can enhance it

Establishing desk buildings and relationships, assigning fundamental keys, environment box requisites, and establishing views

Ensuring the proper point of information integrity for every application

Identifying and setting up company rules

Whatever relational database structures you utilize, Hernandez might help you layout databases which are powerful and reliable. by no means designed a database sooner than? Settling for insufficient conventional designs? working present databases that desire development? begin here.

Show description

Read Online or Download Database design for mere mortals: a hands-on guide to relational database design PDF

Similar data modeling & design books

Designing Database Applications with Objects and Rules: The Idea Methodology

Is helping you grasp the newest advances in glossy database expertise with thought, a cutting-edge method for constructing, retaining, and utilizing database platforms. comprises case reports and examples.


Ziel dieser Arbeit ist die Entwicklung und Darstellung eines umfassenden Konzeptes zur optimalen Gestaltung von Informationen. Ausgangspunkt ist die steigende Diskrepanz zwischen der biologisch begrenzten Kapazität der menschlichen Informationsverarbeitung und einem ständig steigenden Informationsangebot.

Physically-Based Modeling for Computer Graphics. A Structured Approach

Physically-Based Modeling for special effects: A based procedure addresses the problem of designing and coping with the complexity of physically-based types. This ebook can be of curiosity to researchers, special effects practitioners, mathematicians, engineers, animators, software program builders and people drawn to computing device implementation and simulation of mathematical types.

Practical Parallel Programming

This is often the e-book that would educate programmers to write down swifter, extra effective code for parallel processors. The reader is brought to an unlimited array of tactics and paradigms on which real coding can be dependent. Examples and real-life simulations utilizing those units are provided in C and FORTRAN.

Extra info for Database design for mere mortals: a hands-on guide to relational database design

Sample text

Perhaps you learned a design methodology back in college or attended a database class that discussed design, but your memory is vague about some details, or there were parts of the design process that you just did not completely understand. Those points with which you had difficulty will finally become clear once you learn and understand the design process presented in this book. This book is also appropriate for those of you who are experienced database developers and programmers. Although you may already know many of the aspects of the design process presented here, you’ll probably find that there are some elements that you’ve never before encountered or considered.

He’s been a contributing author to a wide variety of magazine columns, white papers, books, and periodicals, and is coauthor of the best-selling SQL Queries for Mere Mortals® (Addison-Wesley, 2007). Mike has been a top-rated and noted technical trainer for the government, the military, the private sector, and companies throughout the United States. He has spoken at numerous national and international conferences, and has consistently been a top-rated speaker and presenter. Aside from his technical background, Mike has a diverse set of skills and interests that he also pursues, ranging from the artistic to the metaphysical.

This book definitely benefitted from their contributions. My thanks once again to each of you for your time and input and for helping to make this edition even better than I first envisioned. I want to extend a very special thanks to Ken Getz for once again providing the foreword for my book. Ken is a well-respected expert, a colleague, and a good friend. I’m so pleased to have his thoughts and comments at the beginning of the book. A special thanks also goes to all of those readers who took the time to send me their thoughts and comments.

Download PDF sample

Rated 4.18 of 5 – based on 35 votes