Lesson 5. Working with Table Relationships

After you add the tables to your database, you next establish relationships between them. This helps to ensure the integrity of the data that users enter into the system. In this lesson, you learn:

Image What relationships are and why you would want to use them

Image How to work with database diagrams

Image How to work with table relationships

How to designate table and column specifications

How to add a relationship name ...

Get Sams Teach Yourself T-SQL in One Hour a Day now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.