In SharePoint 2010, Referential Integrity is enforced by using two options available with Look-up columns. While creating a Look-up column, you have two options :
1. Restrict Delete
2. Cascade Delete
These options define a relationship between the Look-up list and the list containing the look-up Column.