>A question came up in the exam chat today about which tier referential integrity should belong in.
>
>Reasons for it being in the data tier:

Data tier is the container level ( Where the physical layout of the stored Data is ) the relation is done with primary keys. The relations are belong the data structure and defined without any data on it.


>Reasons for it being in the biz tier:

>- domain expert may make "relation integrity" statements like "if a sales person is fired, move all of their customers to his boss". Clearly this is a business rule.
>

This is not referential integrity.
This is the contained level ( The level of the information in the data container ) this relation is not a data referentiel relation but a contained information relation the relation is done with any key. Nothing to do with referential integrity


Marcel