Master the basics of designing relational databases with Visual Studio and SQL Server 2005

For the most part, the process of creating a database is hidden from us by a database application's IDE: we just use drag-and-drop or use wizards to build the databases and tables we want. This works fine for many situations, but without an in-depth understanding of how to best create, tune, and protect a relational database, it is likely that the relational "normalcy," relational integrity constraints, performance, and scalability of the result might not be optimal. And, more importantly, your data may not be particularly secure. Kick start your mastery of relational database design with this sample chapter from Hitchhiker's Guide to Visual Studio and SQL Server: Best Practice Architectures and Examples. Explore both formal rules and informal tips to normalize your database and learn how to build databases that will perform better, be easier to maintain, and be more successful.

Title: Hitchhiker's Guide to Visual Studio and SQL Server: Best Practice Architectures and Examples
ISBN: 0321243625
Published: November 2006
Authors: William R. Vaughn with Peter Blackburn
Chapter: Chapter 3: Relational Databases 101
Published by Addison Wesley Professional