Relationship types, existence, and cardinality generated from the XML Schema to Logical Data Model transformation

The XML Schema to Logical Data Model transformation generates relationship types, existence, and cardinality for the logical data model based on the XML schema contained element occurrences.

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.

Table 1. XML schema Contained Elements to logical data model relationship mappings
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..*)

Feedback