Chapter II.6. Understanding Relationships
Chances are, the store where you picked up this book has an entire section devoted to understanding and improving relationships. You can probably find all sorts of helpful information about bettering your relationships with parents, children, friends, neighbors, and co-workers. In this chapter, we add another relationship that you must consider: the relationship among your SQL Server data.
To begin, we show you why relationships are so important in any modern database management system. Next, you see the different types of relationships that are commonly found in SQL Server (or any other current relational database management system for that matter). With that out of the way, you find out how to use the tools provided by SQL Server to define and maintain these relationships. Finally, because all relationships have problems from time to time, the chapter closes by showing you what happens when a relationship goes bad.
Get Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies® 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.
