Create a foundation for intelligent applications1 / 5
A conference organizer models sessions and speakers with a many-to-many relationship and asks whether the speaker's role for each session can be stored on the relationship itself. What does the many-to-many relationship documentation state?
CorrectIncorrect
Alex
A many-to-many relationship is reciprocal: the rows on either side are peers and there is no explicit hierarchy, so there are no lookup columns and no delete behaviours to configure. The associations live in a relationship table, sometimes called an intersect table, which has a one-to-many relationship with each of the two related tables. That table is deliberately minimal and closed, holding only the values needed to define the association. Whenever the association itself has to carry data, such as a role, a date or a status, the correct model is a separate table joined by two one-to-many relationships instead. Recognizing that limit early avoids a redesign once the first attribute has to hang off the association.
Sourcelearn.microsoft.com
Follow-up answers are available in the app. Create a free account — no credit card required.
Question 1 of 5
Create a free account