Email	Print Reprint
	add to:
	Del.icio.us Digg Google Furl	Slashdot Y! MyWeb Blink
	TABLE OF CONTENTS Introduction Understanding Relational Database Normalization Creating Tables, Rows, and Columns Identifiers Using Identity or GUID Primary Keys Understanding Parents and Children Naming Objects Creating Table Indexes Decimal vs. Floating Point Working with Imprecise Numbers Summary

Summary

This chapter gives you a kick-start on designing relational databases that can perform better, be easier to maintain, and be more successful. That's usually an unspoken goal of any database application project. Unless it's successful, you'll either be back working on it when you should be home relaxing or be out looking for another job—without a good recommendation from your last employer. I talked about both formal rules and informal suggestions to normalize your database. Understand that few of these rules are cast in stone, but until you fully understand them, the databases you (and your team) design and implement, populate and test, and polish and deploy won't keep bread on the table.

---

Excerpted from Hitchhiker's Guide to Visual Studio and SQL Server: Best Practice Architectures and Examples by William R. Vaughn with Peter Blackburn

© Copyright Pearson Education. All rights reserved.

Previous Page | 1 Introduction | 2 Understanding Relational Database Normalization | 3 Creating Tables, Rows, and Columns | 4 Identifiers | 5 Using Identity or GUID Primary Keys | 6 Understanding Parents and Children | 7 Naming Objects | 8 Creating Table Indexes | 9 Decimal vs. Floating Point | 10 Working with Imprecise Numbers | 11 Summary

RELATED ARTICLES Securing the Java Core Petascale Tools and Genomic Evolution Legal Compliance: Open Source and Quality Assurance SEI, Army Team Up on Software Testing Nozzle: Counteracting Memory Exploits		TOP 5 ARTICLES No Top Articles.