✏️ Explanatory Question

What are bridge tables, and when should they be used?

👁 14 Views
📘 Detailed Answer
🟢 Easy
💡

Answer with Explanation

Bridge tables replace N:N relationships by using two 1:N relationships. They allow storing additional attributes about the relationship (e.g., role, priority). They are ideal when relationship metadata is required, though they add UI complexity.