Re: Foriegn Key Question

From: Arto Viitanen <arto.viitanen_at_csc.fi>
Date: Mon, 14 Aug 2006 08:23:47 +0300
Message-ID: <44e008e2$0$1717$ba624cd0@newsread.funet.fi>

Frank van Bortel wrote:

> For the record: that is called an 'intersection table'.
> Common approach for Oracle, or any RDBMS, to implement
> M:M relationships.
>
> See it as the best technically possible solution to
> modeling M:M relations
>

And also for the record: same table can be used also for 1:N relationships, when not all N side records participate (like in this case).

-- 
Arto Viitanen, CSC Ltd.
Espoo, Finland

Received on Mon Aug 14 2006 - 00:23:47 CDT