Forum Post: composite foreign keys

  • Thread starter Thread starter jmls
  • Start date Start date
Status
Not open for further replies.
J

jmls

Guest
As large and vitriolic discussions seemed to have died down recently and I have lost a source of entertainment, I thought that I'd throw this to the list ... I was having a discussion with a colleague today about having a foreign key that is multi-component index I questioned how common this would be , and the answer was "more common than you think" Surely this is inherently a bad database design ? After all, it violates TNF etc etc what's the consensus ? Have I been a pedantic db designer all my life ? Is there something that I am missing ? Or is it simply bad db design to have this sort of construct ? please say the latter ... ;)

Continue reading...
 
Status
Not open for further replies.
Back
Top