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

Get A Developer’s Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.