When an XML schema is transformed to a relational schema automatically, the following transformation rules will be applied:
Note: The value of the Is Multiple property of a simple element is defined by the value of its maxOccurs property in the XSD. If you modify it and make it not match with the maxOccurs property in the transformation process, the element will be transformed according to the Is Multiple property regardless of the maxOccurs property. The following are the two conditions:
Here presents four illustrative examples for you to understand the transformation rules more easily: