Re: How to work with m:n relationships?
Date: 24 Feb 2006 12:36:05 -0800
Message-ID: <1140813365.199655.91920_at_z34g2000cwc.googlegroups.com>
As previous discussants in this thread (Leffler and Portas) didn't
presented the solution which they prefer (the current solutions in RM
like [TDRM] and similar), let me make a very short analysis of this
kind of the solutions.
Using example from this thread the current RM's solutions will assign
following key for the relation Subscriber: Primary Key (ssn, mm, dd,
yy, hh, mm, ss), that is 7 attributes. Similarly for the Relation
Product: Primary Key (product_code, mm1, dd1, yy1, hh1, mm1, ss1) that
is 7 attributes.
Join relation SubscriberProduct will have 20 attributes. This is just
very short analysis and the application is not to much complicate.
In my solution Key has one attribute.
Vladimir Odrljin Received on Fri Feb 24 2006 - 21:36:05 CET