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

Get Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours now with the O’Reilly learning platform.

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