A Developer’s Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008

CHAPTER 9CREATING THE PHYSICAL MODEL WITH SQL SERVER

We have come a long way since we started our discussion about data modeling, but now we are on the downhill slide. You have done all the hard work—gathering requirements, transforming them into a logical model, and acquiring customer approval of that model. Throughout this process you had to make sure to avoid common problems and keep everything normalized to a reasonable level.

Now it’s time to use the logical model and the business requirements to come up with your physical model. This physical model will become your actual database in SQL Server. This chapter first covers the naming guidelines we suggest for SQL Server objects, and then we talk about creating your physical model. So without ...