Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is a Junction-Table basically just the table that sits between two entities that have a M-M relationship?

share|improve this question
up vote 8 down vote accepted

A junction table is a weak entity, but a weak entity often is not a junction table. A junction table is not the same as a weak entity. A junction table is a type of weak entity.

Tables used to resolve repeating groups are also weak entities. These are only junction tables if the repeating group contains a repeated foreign key relationship.

share|improve this answer
Should this read, "...but a weak entity may not be..."? – Air Dec 18 '13 at 22:34
@AirThomas I believe may not would imply likely is which I did not want to do. Similarly I would state A coin may be a quarter rather than A coin may not be a quarter. – BillThor Dec 19 '13 at 1:07

Depends how you define a "junction table". ER terminology tends to be somewhat ambiguous when used to describe relational database concepts.

A junction table typically means or can mean any table with two or more foreign keys.

A weak entity on the other hand is represented by a table whose primary key includes at least one foreign key attribute. That doesn't have to be the case for a junction table (i.e. a table with more than one foreign key).

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.