Associative Entity

An entity representing a relationship and optionally storing attributes about that relationship.

What is Associative Entity in a relational database?

Associative Entity — An entity representing a relationship and optionally storing attributes about that relationship.

CREATE TABLE enrollment (
    student_id INTEGER REFERENCES student (student_id),
    course_id INTEGER REFERENCES course (course_id),
    PRIMARY KEY (student_id, course_id)
);

Level: Journeyman · More Database terms at this level

Updated September 27, 2026