More Than Two Parents?

A bridge table is used to represent a complex relationship between the records in multiple tables. Although relationships are most common between two tables (i.e., binary), it isn't hard to imagine a situation where there is a relationship between the records in three, four or more tables (i.e., N-ary).

More FAQs