Re: Manage many to many relationship between "N" number of tables

steven.p24_at_googlemail.com wrote:
> Hi All,
>
> Problem:
>
> Say i have 3 tables A, B & C in my db. They can have Many to Many
> relation ship with each other i.e.

Three is a simple solution to the problem. Many to many relationships are not allowed in a well designed RDBMS. Create intersecting entities, tables holding the primary keys of the other tables, so that all relationships are 1:M.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org