The following table shows the mappings from a XML schema contained element occurrences to the relationship type, existence, and cardinality for the logical data model.
XML schema - contained elements | XML schema - MinOccurs / MaxOccurs of parent contained element | XML schema - MinOccurs / MaxOccurs of child Contained Element | Logical data model - relationship type | Logical data model - existence | Logical data model - cardinality |
---|---|---|---|---|---|
Unidirectional | (0..1)/1/*/(1..*) | n/a | Identifying | Not applicable (mandatory) | (0..1)/1/*/(1..*) |
Bidirectional | (0..1)/1/*/(1..*) | 0..1 | Non-identifying | Optional | (0..1)/1/*/(1..*) |
Bidirectional | (0..1)/1/*/(1..*) | 1 | Non-identifying | Mandatory | (0..1)/1/*/(1..*) |
Bidirectional | */(1..*) | * | Many to many | Optional | */(1..*) |
Bidirectional | */(1..*) | 1..* | Many to many | Mandatory | */(1..*) |