JoinTabelle
JoinTabelle, also called join table or junction table, is a database table used to implement many-to-many relationships between two other tables by storing pairs of foreign keys. It serves as an intermediary that connects related records from the two tables.
Structure and keys: A join table typically contains two (or more) foreign key columns, each referencing the
Example: In a university database, a join table named Enrollment connects Students and Courses. It might contain
Design considerations: Key goals are normalization and referential integrity. Indexing the foreign keys improves join performance.
Variants and usage: Join tables are also called bridging tables or linking tables. In some ORM systems,
See also: many-to-many relationships, foreign keys, relational databases, normalization.