Question

referential integrity

Referential integrity, Database

quick question about referential integrity:

let's say i have 4 tables:

A table has NAME
B table has NAME, CODE
C table has CODE
D table has NAME, CODE, ELSE

A (NAME) is referenced by B (NAME)and C (CODE) is Referenced by B (CODE)

if i reference B (NAME, CODE) from D, do i need to reference A (NAME) and C (CODE) as well (from D)

Hi,

I think you've got it covered without referencing A and C to D.

Regards,

Martin Gilbert.