Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: For the SQL Gurus out there, a question
John Pifer wrote:
> I am not good at SQL - hence here goes
>
> Consider this scenario of 2 tables X and Y with a many to many
> relationship
Lets just stop right here!
The example is by definition an example of bad design. All many-to-many relationships must be resolved when moving from a logical design to a physical design.
Fix the design problem!
That is the only acceptable solution.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Sun Feb 08 2004 - 14:06:28 CST