patternMinor
Is a “‘Junction’ Table” the same as a Weak Entity?
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.
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.