About: Associative entity

Facets (new session)
Description
Metadata
Settings
- Rule:
- Inverse Functional Properties:
- "Same As":

About: Associative entity Goto Sponge NotDistinct Permalink

An Entity of Type : owl:Thing, within Data Space : el.dbpedia.org associated with source document(s)

An associative entity is a term used in relational and entity–relationship theory. A relational database requires the implementation of a base relation (or base table) to resolve many-to-many relationships. A base relation representing this kind of entity is called, informally, an associative table. As mentioned above, associative entities are implemented in a database structure using associative tables, which are tables that can contain references to columns from the same or different database tables within the same database.

Attributes	Values
rdfs:label	Associative entity (en)
rdfs:comment	An associative entity is a term used in relational and entity–relationship theory. A relational database requires the implementation of a base relation (or base table) to resolve many-to-many relationships. A base relation representing this kind of entity is called, informally, an associative table. As mentioned above, associative entities are implemented in a database structure using associative tables, which are tables that can contain references to columns from the same or different database tables within the same database. (en)
sameAs	Associative entity Associative entity Associative entity
dbp:wikiPageUsesTemplate	dbt:Cite_book dbt:Cite_journal dbt:No_footnotes dbt:Reflist
Subject	Diagrams Entity–relationship model
thumbnail	wiki-commons:Special:FilePath/Associate_Entity.png?width=300
foaf:depiction
gold:hypernym	Term
prov:wasDerivedFrom	http://en.wikipedia.org/wiki/Associative_entity?oldid=1039456516&ns=0
Wikipage page ID	8859696 (xsd:integer)
page length (characters) of wiki page	4381 (xsd:nonNegativeInteger)
Wikipage revision ID	1039456516 (xsd:integer)
Link from a Wikipage to another Wikipage	Foreign key Unique key Select (SQL) Diagrams Entity–relationship model Pivot table Primary key Entity–relationship model Insert (SQL) Join (SQL) Many-to-many (data model) Laravel Relational database Relational model
has abstract	An associative entity is a term used in relational and entity–relationship theory. A relational database requires the implementation of a base relation (or base table) to resolve many-to-many relationships. A base relation representing this kind of entity is called, informally, an associative table. As mentioned above, associative entities are implemented in a database structure using associative tables, which are tables that can contain references to columns from the same or different database tables within the same database. An associative (or junction) table maps two or more tables together by referencing the primary keys (PK) of each data table. In effect, it contains a number of foreign keys (FK), each in a many-to-one relationship from the junction table to the individual data tables. The PK of the associative table is typically composed of the FK columns themselves. Associative tables are colloquially known under many names, including association table, bridge table, cross-reference table, crosswalk, intermediary table, intersection table, join table, junction table, link table, linking table, many-to-many resolver, map table, mapping table, pairing table, pivot table (as used incorrectly in Laravel - not to be confused with the correct use of pivot table in spreadsheets), or transition table. (en)
foaf:isPrimaryTopicOf	http://en.wikipedia.org/wiki/Associative_entity
is Wikipage redirect of	Intersection table Junction table Bridge Table Link Table Link table Linking table Bridge table Cross-reference table Join Table Join table Many-to-many resolver Map Table Mapping table Association table Associative Entities Associative entities
is Link from a Wikipage to another Wikipage of	Foreign key Intersection table Airtable CakePHP Junction table Object–relational mapping Cross-reference Crosswalk (disambiguation) Entity–relationship model Fact table Many-to-many (data model) Bridge Table Link Table Link table Linking table Bridge table Cross-reference table Join Table Join table Many-to-many resolver Map Table Mapping table Association table Associative Entities Associative entities
is foaf:primaryTopic of	http://en.wikipedia.org/wiki/Associative_entity

Faceted Search & Find service v1.17_git151 as of Feb 20 2025

Alternative Linked Data Documents: ODE Content Formats:

RDF

ODATA

Microdata

About

OpenLink Virtuoso version 07.20.3240 as of Nov 11 2024, on Linux (x86_64-ubuntu_focal-linux-gnu), Single-Server Edition (72 GB total memory, 933 MB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2025 OpenLink Software