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 7CREATING THE LOGICAL MODEL

Everything you’ve read until now has been laying the foundation for building a data model. In this chapter, we finally start to use the concepts introduced in the first six chapters. We begin by taking a look at the modeling semantics, or notation standards, and discussing the features you’ll need in a modeling tool. Then we work through the process of turning requirements into organized pieces of data, such as entity lists. Finally, after we have created all the objects that our model needs, we build the model, deriving its form and content from all the pieces of information we’ve gathered. So let’s dig in.

Diagramming a Data Model

Obviously, most of the concepts we’ve covered are just that—conceptualized ...

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