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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
