O'Reilly logo

Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

HOUR 5. Working with Table Relationships

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

What relationships are and why you would want to use them

How to work with database diagrams

How to work with table relationships

How to designate table and column specifications

How to add a relationship name and description

How to determine when foreign key relationships constrain the data entered in a column

How to designate INSERT and UPDATE specifications

An Introduction to Relationships

Three types of relationships can exist between tables in a database: one-to-many, one-to-one, and many-to-many. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required