Difference between revisions of "Associative entity"
From Wiki @ Karl Jones dot com
Karl Jones (Talk | contribs) (etc) |
Karl Jones (Talk | contribs) |
||
| 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 [[ | + | == Description == |
| + | |||
| + | The [[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. | The solution to this problem is the creation of another table to hold the necessary information for this relationship. | ||
| Line 10: | Line 12: | ||
* [[Data model]] | * [[Data model]] | ||
| + | * [[Database relational model]] | ||
* [[Entity-relationship model]] | * [[Entity-relationship model]] | ||
| + | * [[Many-to-many relationships]] | ||
| + | * [[Relational model]] | ||
== External links == | == External links == | ||
* [https://en.wikipedia.org/wiki/Associative_entity Associative entity] @ Wikipedia | * [https://en.wikipedia.org/wiki/Associative_entity Associative entity] @ Wikipedia | ||
Revision as of 10:18, 2 September 2015
An associative entity is an element of the Entity-relationship model.
Description
The 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.
See also
- Data model
- Database relational model
- Entity-relationship model
- Many-to-many relationships
- Relational model
External links
- Associative entity @ Wikipedia
