Answer-first summary for fast verification
Answer: Use a bridge table to manage many-to-many relationships, recognizing the benefits and addressing potential maintenance challenges.
Bridge tables are essential for managing many-to-many relationships in a semantic model, providing clarity and reducing complexity. However, they require careful management to ensure data integrity and performance.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Explain how you would implement a bridge table in a semantic model to manage a many-to-many relationship. Discuss the benefits of using a bridge table and the potential challenges in maintaining it.
A
Avoid using bridge tables to keep the model simple.
B
Implement a bridge table without considering maintenance challenges.
C
Use a bridge table to manage many-to-many relationships, recognizing the benefits and addressing potential maintenance challenges.
D
Implement many-to-many relationships without using a bridge table.
No comments yet.