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.
Notifications
Clear all