O'Reilly logo

A Developer’s Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008 by Joshua Jones, Eric Johnson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required