When you transform a physical data model into a logical data model,
certain naming rules are used. Physical data objects are transformed into
corresponding logical data objects according to certain rules.
When a physical data model is transformed to a logical data model,
table and column names are transformed to entity and attribute names according
to the following rules:
- The name of each physical data object is used for the corresponding logical
data object.
- The separator character that is defined for physical data objects on the Naming
Standard Preferences page is replaced by the separator character
that is defined for logical data objects on the Naming Standard Preference
page.
Physical data objects are transformed to logical data objects
according to the following rules.
Table 1. Physical to logical
to data model object mappingsPhysical data object or property |
Physical data object or property generated by the transform |
Table |
Entity |
Column |
Attribute |
Foreign key constraint and relationship |
Foreign key and relationship |
Primary key constraint |
Primary key |