Difference between revisions of "Associative entity"

From Wiki @ Karl Jones dot com
Jump to: navigation, search
(First)
 
(Entity-relationship model)
Line 1: Line 1:
An '''associative entity''' is an element of the [[entity–relationship model]].
+
An '''associative entity''' is an element of the [[Entity-relationship model]].
  
 
The database relational model does not offer direct support to many-to-many relationships, even though such relationships happen frequently in normal usage.
 
The database relational model does not offer direct support to many-to-many relationships, even though such relationships happen frequently in normal usage.

Revision as of 17:07, 5 June 2015

An associative entity is an element of the Entity-relationship model.

The database relational model does not offer direct support to many-to-many relationships, even though such relationships happen frequently in normal usage.

The solution to this problem is the creation of another table to hold the necessary information for this relationship.

This new table is called an associative entity.

External links