Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: logical differing from physical
Cherie,
Can you tell me which normal form a many-many relationship violate? Thanks.
I know how to implement it. But I'm curious about its violation of normal form.
Yong Huang
yong321_at_yahoo.com
you wrote:
A many-to-many relationship violates the rules of normal form.
You have to put the extra table in between to have one-to-many
on each side of the intermediate table. Thus you eliminate the
many-to-many relationship.
Cherie