A Developer's Guide to Data Modeling for SQL Server.pdf

Praise for A Developer’s Guide to Data Modeling

for SQL Server

“Eric and Joshua do an excellent job explaining the importance of data modeling and how

to do it correctly. Rather than relying only on academic concepts, they use real-world ex-

amples to illustrate the important concepts that many database and application develop-

ers tend to ignore. The writing style is conversational and accessible to both database

design novices and seasoned pros alike. Readers who are responsible for designing, imple-

menting, and managing databases will benefit greatly from Joshua’s and Eric’s expertise.”

—Anil Desai, Consultant, Anil Desai, Inc.

“Almost every IT project involves data storage of some kind, and for most that means a

relational database management system (RDBMS). This book is written for a database-

centric audience (database modelers, architects, designers, developers, etc.). The authors

do a great job of showing us how to take a project from its initial stages of requirements

gathering all the way through to implementation. Along the way we learn how to handle

some of the real-world design issues that typically surface as we go through the process.

“The bottom line here is simple. This is the book you want to have just finished read-

ing when your boss says ‘We have a new project I would like your help with.’”

—Ronald Landers, Technical Consultant, IT Professionals, Inc.

“The Data Model is the foundation of the application. I’m pleased to see additional books

being written to address this critical phase. This book presents a balanced and pragmatic

view with the right priorities to get your SQL server project off to a great start and a long

life.”

—Paul Nielsen, SQL Server MVP, SQLServerBible.com

“This is a truly excellent introduction to the database design methodology that will work

for both novices and advanced designers. The authors do a good job at explaining the ba-

sics of relational database modeling and how they fit into modern business architecture.

This book teaches us how to identify the business problems that have to be satisfied by a

database and then proceeds to explain how to build a solid solution from scratch.”

—Alexzander N. Nepomnjashiy, Microsoft SQL Server DBA,

NeoSystems North-West, Inc.

“ A Developer’s Guide to Data Modeling for SQL Server explains the concepts and prac-

tice of data modeling with a clarity that makes the technology accessible to anyone build-

ing databases and data-driven applications.

“Eric Johnson and Joshua Jones combine a deep understanding of the science of data

modeling with the art that comes with years of experience. If you’re new to data model-

ing, or find the need to brush up on its concepts, this book is for you.”

— Peter Varhol, Executive Editor, Redmond Magazine

This page intentionally left blank

A Developer’s Guide

to Data Modeling

for SQL Server

C OVERING SQL S ERVER

2005 AND 2008

This page intentionally left blank