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 mappingsLogical 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..*) |