Suppose that two columns in two different tables have the same column name. What convention is used to give each a unique name?
To name two columns in two different table with uniquely when they happen to have the same name, we add their respective table name to their names. For example we have two tables called Salespersons and Supervisors and both have a Salary column we can use the above convention in the following way:
Salespersons_Salary and Supervisors_Salary