Re: Manage many to many relationship between "N" number of tables
Date: Wed, 02 Jan 2008 20:42:59 -0800
> Hi All,
> 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.orgReceived on Wed Jan 02 2008 - 22:42:59 CST