many-to-manyrelationshipentity-relationshiperdconceptual-model

An associative Entity with optional participation on one side and mandatory participation on the other


I get confused sometimes when trying to understand business rules and translating them into ERD using Crow's Foot Notation.

This is the Business Rule:

This is what I did:

This is what I did

My Questions:


Solution

  • Yes it is correct, but:

    When using an associative table, the one side of the decomposition should have mandatory participation. If it would not be mandatory, you could have rows in the associative table that corresponds to not have a conter-part and hence do not correspond to a valid relationship between the two associated entities. Imagine for example that the student would receive a grade for each of the enrolments. If one side would be missing, the grade would then be completely irrelevant.