The 1 Easy Commonsense Guide to Database Design! Michael J. Hernandez's best-selling Database Design for Mere Mortals (r) 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 & best practices. Step by step Database Design for Mere Mortals (r) Third Edition shows you how to design databases that are soundly structured reliable & flexible even in modern web applications. Hernandez guides you through everything from database planning to defining tables fields keys table relationships business rules & views. You'll learn practical ways to improve data integrity how to avoid common mistakes & when to break the rules. Coverage
Includes:: Understanding database types models & 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 & transforming those objectives into real designs Analyzing a current database so you can identify ways to improve it Establishing table structures & relationships assigning primary keys setting field specifications & setting up views Ensuring the appropriate level of data integrity for each application Identifying & establishing business rules Whatever relational database systems you use Hernandez will help you design databases that are robust & trustworthy. Never designed a database before? Settling for inadequate generic designs? Running existing databases that need improvement? Start here.