HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Is a “‘Junction’ Table” the same as a Weak Entity?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
sametheweakjunctiontableentity

Problem

Is a “‘Junction’-Table” basically just the table that sits between two entities that have a many-to-many (M-M) relationship?

Solution

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.

Context

StackExchange Database Administrators Q#2134, answer score: 9

Revisions (0)

No revisions yet.