I’d like to take this logical model:
facility category identifier
and create the following relational model:
I’ve created the logical model and used ‘Simple Model Conversion’ to convert to Oracle 10g.
I then applied the following naming convention to the physical model:
General: Everything checked.
Naming Convention Rules:
‘entities’ prefix ‘t_’ case ‘lowercase’
‘attributes’ prefix none case ‘lowercase’
Glossary Character Replacement: =_ (i.e., =)
Glossary Word Replacement:
The ‘t_’ prefix worked. The space replacement with underscores worked. Entity ‘facility’ was abbreviated to ‘fac’. However, none of the other abbreviations were applied. It appears the space->underscore replacement occurs first and prevents the matching of the rest of the abbreviations. If that is what is happening, is there another way to get the naming I want?