CHAPTER 5Implementing the Base Table Structures

The doctor of the future will give no medicine, but will interest her or his patients in the care of the human frame, in a proper diet, and in the cause and prevention of disease.

—Thomas A. Edison

Much like Thomas Edison expected doctors would be in the future, so must we be as data architects. In the logical design part of this book (the first four chapters), I discussed in quite some detail the process of defining the structure of the data the user needs to store. I did this not so you could solve problems as you observe them but rather so you can avoid problems by preventing them.

In this chapter, I'll take a logical model, convert it into a blueprint for the database implementation, and ...

Get Pro SQL Server 2008 Relational Database Design and Implementation now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.