Database Design - Tricky

Imagine three tables C, R and B. C has a primary key of CKEY, R is RKEY and B is BKEY.

Another table NEWS has a primary key of NEWSKEY.

C, R and B can all be associated with zero to many NEWS items. Any NEWS item can be associated with C and/or R and/or B.

One model is to put an intersection table between NEWS and C, NEWS and B, and NEWS and R.

But when I add more tables at the level of C, R and B then I will need more intersection tables. Is there a more elegant solution? Please be specific about which would be the key and foreign key columns of any alternative solution.

Many thanks,

Van

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Fri Jul 21 2000 - 00:00:00 CDT