UML association types and multiplicity of role generated by logical data model-to-UML transformation

The logical data model-to-UML transformation generates UML association types and multiplicity of role from the relationship types, existence, and cardinality of a logical data model.
The following table shows the mappings from the relationship type, existence, and cardinality of a logical data model to the UML association type or multiplicity of role.
Table 1. Logical data model relationship to UML association mappings
Logical data model - relationship type Logical data model - existence Logical data model - cardinality UML - association type UML - multiplicity of parent role UML - multiplicity of child role
Many to many Optional */ (1..*) Simple * */(1..*)
Many to many Mandatory */(1..*) Simple 1..* */(1..*)
Non-identifying Optional (0..1) /1/*/(1..*) Aggregation (0..1) (0..1) /1/*/(1..*)
Non-identifying Mandatory (0..1) /1/*/(1..*) Aggregation 1 (0..1) /1/*/(1..*)
Identifying Not applicable (mandatory) (0..1) /1/*/(1..*) Composition 1 (0..1) /1/*/(1..*)

Feedback