Notifications
Clear all

Links with varying cardinality  


Posts: 21
Topic starter
(@susan-tholen)
Eminent Member
Joined: 3 months ago

Suppose I have a link between 3 hubs which represents a real business relationship that is applicable to most of our products... but for one of the products one of those elements is not present.  I could model the link as a 3-way link and just leave the field null for the product where it does not apply or I could have product-specific link tables.  Is there anything about having some null relationships that makes the former choice a bad idea?  I can't think of any major reason not to do that.

Reply
4 Replies