A Developer's Guide to Data Modeling for SQL Server {purestevil}™

A Developer's Guide to Data Modeling for SQL Server: Covering SQL 2005 and 2008 [h33t] {purestevil}™release









Publication Info:



Author(s) : Eric Johnson, Joshua Jones

Publisher : Addison-Wesley Professional

Date : 2008

Pages : 299

Format : PDF

ISBN-10 : 0321497643





Book Info:



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