Author(s) : Eric Johnson, Joshua Jones
Publisher : Addison-Wesley Professional
Date       : 2008
Pages     : 299
Format    : PDF
ISBN-10  : 0321497643

This book enables you to:
- Understand your data model's physical elements, from storage to referential integrity
- Provide programmability via stored procedures, user-defined functions, triggers, and .NET CLR integration
- Normalize data models, one step at a time
- Gather and interpret requirements more effectively
- Learn an effective methodology for creating logical models
- Overcome modeling problems related to entities, attribute, data types, storage overhead, performance, and relationships
- Create physical models from establishing naming guidelines through implementing business rules and constraints
- Use SQL Server's unique indexing capabilities, and overcome their limitations
- Create abstraction layers that enhance security, extensibility, and flexibility