Applying Naming and Datatype Standards › Applying Naming Standards › Create and Apply Naming Standards › Example

Example

You have two tables, Customer and Accounts. The Customer table has First Name and Last Name columns.

Suppose you want to implement the following standards:

• Prefix the names of the tables with Tbl_.
• Display First Name as Col_FNAME and Last Name as Col_LNAME.

How you do it:

1. Add an NSM Object and make it active.
2. In the Logical tab, for Entity and Attribute, select Modifier 1 in the Part 1 and Prime in the Part 2 column.
3. In the Physical tab, for the Table and Column object types, select Modifier 1 in the Part 1 and Prime in the Part 2 column.
4. In the Glossary tab, add First Name and Last Name and the corresponding abbreviations. Select the P check box.
5. Open the Model Naming Options dialog and click the Name Mapping tab.
6. Select the Use Glossary check box for Entity to Table and Attribute to Column rows. In the Prefix column, enter Tbl_ in the first row and Col_ in the third row. Click Close.

   The standards that you have defined are applied to the model.

Back to Top