By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user tries to delete or update a key to which existing foreign keys point.

A foreign key is a relationship between two entities ... Gathering history very often means that each object within the database design may have columns like a “Start Date” and an “End Date” ...