You can create entity relationships from an XML schema. When you create an XML definition that contains entity relationships, the Designer generates separate views for multiple-occurring elements, element groups, and complex types. The Designer includes views for all derived complex types. The Designer creates links and keys between the views based on type and hierarchy relationships.

When you work with XML schemas, you can reference parts of the schema rather than repeat the same information in schema components. A component can inherit the elements and attributes of another component and restrict or extend the elements from the component. For example, you might use a complex type as a base for creating a new complex type. You can add more elements to the new type to create an extended complex type. Or, you might create a restricted complex type, which is a subset of another complex type.

If you create views manually or re-create entity relationships in the XML Editor, you choose how you want to structure the metadata. When you create an XML definition based on an XML schema that uses inheritance, you can generate separate views for the base type and derived type. You might create inheritance relationships if you plan to map the XML data to normalized relational tables.

An XML Type I inheritance relationship is a relationship between two views. Each view root is a global complex type. One view is derived from the other.

You can create an inheritance relationship between a column and a view. This is an XML Type II inheritance relationship.

The Designer generates separate views for substitution groups.