When a logical data model is transformed to a physical data model,
entity and attribute names are transformed to table and column names according
to the following rules:
- If an entity has a defined abbreviation property, the corresponding table
is named according to the abbreviation property.
- If an entity does not have a defined abbreviation property, the Transform
to Physical Data Model wizard searches for the entity name in the glossary
models that are specified for the project. If the entity does not have a glossary
model name, or there is no glossary model specified for the project, then
the entity name is used.
- If an attribute has a defined domain property, then the corresponding
column is named according to the name of the domain property.
- If an attribute does not have a defined domain property but has a defined
abbreviation property, the corresponding column is named according to the
abbreviation property.
- If an attribute does not have a defined domain or abbreviation property,
the Transform to Physical Data Model wizard searches for the attribute name
in the glossary models that are specified for the project. If the attribute
does not have a glossary model name, or there is no glossary model specified
for the project, then the attribute name is used.