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