Physical to logical data model object naming rules and object mappings

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 data model object mappings
Physical data object or property Logical 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

Feedback