Center for Academic Computing:

Junction table a table which has a primary key that’s actually a combination of at least the primary keys from two or more tables; a junction table acts as a bridge between the two tables in a many-to-many relationship One-to-One Relationship. One-to-Many Relationship. Many-to-Many Relationship. Implementing Referential Integrity. Orphan Records ................
................