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

From: DA Morgan <>
Date: Wed, 02 Jan 2008 20:42:59 -0800
Message-ID: <> 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 (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Wed Jan 02 2008 - 22:42:59 CST

Original text of this message