Suppose that two columns in two different tables have the same column name. What convention is used to give each a unique name?
This happens often in database development when there are multiple tables with same column names. This could become an issues when these columns have to be recalled for different operations. This issues can be solved easily by amending the column name by including the table name with it. For example if we have an Allowance column in two tables i.e. Employees and Managers tables, we can simply do the following to the name of the Allowance column.
Managers_Allowance and Employees_Allowance.