Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (3rd Edition)

Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (3rd Edition)

Michael J. Hernandez


The number one effortless, common sense advisor to Database layout! Michael J. Hernandez’s best-selling Database layout for Mere Mortals® has earned world wide admire because the clearest, easiest method to profit relational database layout. Now, he’s made this hands-on, software-independent instructional even more straightforward, whereas making sure that his layout method remains to be correct to the newest databases, purposes, and top practices. Step by way of step, Database layout for Mere Mortals ® , 3rd Edition, exhibits you ways to layout databases which are soundly based, trustworthy, and versatile, even in smooth net functions. Hernandez publications you thru every little 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, the way to stay away from universal errors, and while to damage the rules.


Coverage includes

Understanding database kinds, versions, and layout terminology

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

Setting goals to 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 basic keys, atmosphere box necessities, and developing views

Ensuring the proper 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 strong and reliable. by no means designed a database sooner than? Settling for insufficient universal designs? working present databases that desire development? commence here.

Show sample text content

Download sample