CHAPTER 8COMMON DATA MODELING PROBLEMS
Perfecting a data model is no easy task. To do it correctly, you must balance the physical limitations of SQL Server 2008 and simultaneously meet the requirements of your customer’s business. Along the way, there are several pitfalls you may encounter. Many of the problems you will face are quite common, and you can avoid them by understanding them. In this chapter, we discuss some of the more common modeling problems and explain how to identify them, how to fix them if they occur, and how to avoid them altogether.
Entity Problems
Data models are built around entities, so that is where we start when looking for problems. Some entity problems are obvious, and others are a little harder to pick up on and fix. ...
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.
