>I think what Nancy is saying is that RI should be enforced by the biz rules. I agree. However, where that is implemented is what we are debating here. There are valid reasons for doing this with biz objects or letting the data store do it. Either way, it is biz rules that determine how it is done.

I write this in this discussion

>RI preserves relationships between tables when records are entered or deleted, it's not a business rule.
>
>But RI is only a part of the DATA Integrity.
>
>So confusion is comming when some business rules will enforced data rules to hold the DATA Integrity.
>
>But remember n tier is only a responsability layout and the business tiers is a two face layer ( one for Data and one for the User )
>
>So the DATA tier is able to communicate with other tier. ( to ask and receive informations )
>
>But the DATA Integrity is the reponsability of the data tier ( no way out of this !) also when enforced by business rules.

Don't you agree ?