CHAPTER 3PHYSICAL ELEMENTS OF DATA MODELS
Now that you have a grasp of the logical elements used to construct a data model, let’s look at the physical elements. These are the objects that you use to build the database. Most of the objects you build into your physical model are based on objects you created in the logical model. Many physical elements are the same no matter which RDBMS you are using, but we look at all the elements available in SQL Server 2008. It is important to know SQL Server’s capabilities so that you can build your model with them in mind.
In this chapter, we cover all the physical SQL Server objects in detail and walk you through how to use each type of object in your physical model. You will use these elements later in ...
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.
