MySQL Forums :: Database Design & Data Modelling :: Unary many-to-many relationships

Advanced Search

Unary many-to-many relationships
Posted by: Colleen Boye ()
Date: March 02, 2012 12:11PM

What's the proper way to create a unary many-to-many relationship? It seems inefficient to add an associative entity to relate an entity to itself.

For that matter, is a proper relationship even an advantage over just, say, creating an integer field and assigning the same number to all the elements in the relationship?

Options: ReplyQuote

Subject Written By Posted
Unary many-to-many relationships Colleen Boye 03/02/2012 12:11PM
Re: Unary many-to-many relationships Rick James 03/03/2012 09:31AM
Re: Unary many-to-many relationships Peter Brawley 03/04/2012 11:02AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.