Foreign key to subtype or super types?

Question

I'm using SQL Server

and in this case i have the following tables:

Should the foreign key be pointing to Staff (Supertype) or to R&D_Staff (Subtype)

Thanks in advance

gbn · Accepted Answer · 2011-12-14 11:12:52Z

up vote 3 down vote accepted

Re-phrasing, do you mean:

don't allow Sales or Shipping staff values in restock?

Then the foreign key is from Restock to R&D_Staff to allow only values from RnD staff in the Restock table

answered Dec 14 '11 at 11:12

gbn
42.3k353105

Thank you, this is what i meant. – Toby Dec 14 '11 at 11:24

migrated from stackoverflow.com Dec 14 '11 at 14:35