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

By Michael J. Hernandez


The no 1 effortless, common-sense advisor 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 educational even more straightforward, whereas making sure that his layout method continues to be appropriate to the newest databases, purposes, and top practices. Step through step, Database layout for Mere Mortals ® , 3rd Edition, exhibits you ways to layout databases which are soundly based, trustworthy, and versatile, even in glossy net purposes. Hernandez courses you thru every thing from database making plans to defining tables, fields, keys, desk relationships, enterprise ideas, and perspectives. You’ll examine useful how you can increase facts integrity, easy methods to steer clear of universal blunders, and whilst to wreck the rules.


Coverage includes

Understanding database varieties, types, and layout terminology

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

Setting ambitions on your database, and reworking these pursuits into genuine designs

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

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

Ensuring the best point of knowledge integrity for every application

Identifying and developing company rules

Whatever relational database platforms you utilize, Hernandez may help you layout databases which are powerful and reliable. by no means designed a database earlier than? Settling for insufficient prevalent designs? operating latest databases that want development? commence 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

Polynomial Algorithms in Computer Algebra

For numerous years now i've been educating classes in machine algebra on the Universitat Linz, the collage of Delaware, and the Universidad de Alcala de Henares. within the summers of 1990 and 1992 i've got prepared and taught summer season colleges in laptop algebra on the Universitat Linz. steadily a suite after all notes has emerged from those actions.

Data Dissemination and Query in Mobile Social Networks

With the expanding popularization of non-public hand held cellular units, extra humans use them to set up community connectivity and to question and proportion information between themselves within the absence of community infrastructure, growing cellular social networks (MSNet). considering the fact that clients are just intermittently hooked up to MSNets, person mobility might be exploited to bridge community walls and ahead information.

Big Practical Guide to Computer Simulations

"This distinct e-book is a musthave for any scholar making an attempt first steps in desktop simulations. Any new scholar becoming a member of my computational physics team is anticipated to first paintings via Hartmann's consultant sooner than beginning a study venture. " Helmut Katzgraber affiliate Professor Texas A&M collage "This booklet is full of worthy info for everybody doing computing device simulations.

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

Example text

If you’re just getting into database management and you’re thinking about developing your own databases, this book will be very valuable to you. It’s better that you learn how to create a database properly from the beginning than that you learn by trial and error. Believe me, the latter method takes much longer. If you fall into the category of those people who have been working with database programs for a while and are ready to begin developing new databases for your company or business, you should read this book.

These people usually had mathematical, computer science, or systems design backgrounds and typically worked with large mainframe databases. Many of them were experienced programmers and had coded a number of database application programs consisting of thousands of lines of code. ) People designing database systems at that time needed to have a solid educational background because most of the systems they created were meant to be used companywide. Even when creating databases for single departments within a company or for small businesses, database designers still required extensive formal training because of the complexity of the programming languages and database application programs they were using.

The ENGAGEMENTS table will now contain data on entertainers (such as entertainer name, phone number, and type of entertainer) to indicate which entertainers are performing for a given client. This data is redundant as well because it is currently stored in the ENTERTAINERS table. The problem with this redundancy is that it opens up the possibility of allowing a user to enter a single piece of data inconsistently. This, in turn, can result in producing inaccurate information. A user can solve this problem in a roundabout manner by creating one hierarchical database specifically for entertainers and another specifically for agents.

Download PDF sample

Rated 4.73 of 5 – based on 49 votes