File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes remove many to many relationship Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "remove many to many relationship" Watch "remove many to many relationship" New topic

remove many to many relationship

anarkali perera
Ranch Hand

Joined: Sep 10, 2009
Posts: 237
how to remove many to many relation ship on a table?
Campbell Ritchie

Joined: Oct 13, 2005
Posts: 40061
Put something in between.
Man ---- Wife is a one-to-one relationship. (Well, some of the time, anyway )
Brother ---- sister might be a many-to-many relationship. Put something in between; you can have a "sibship" with one brother and one sister and you interpose that between brother and sister
Brother ---- sibship = one-to-many: one brother many have several sibships. Sibship ---- sister = many-to-one: several sibships may lead to one sister.
Brother ---- sibship ---- sister is now no longer a many-to-many.
subject: remove many to many relationship