Thanks for this hlepful framework.
Could you please be more precise about this answer?
I understand 'role of the association' from OR terminology.
However I have a table that is associated with many others for the purpose of maintaining a consistent structure with nomenclatures that vary between business contexts.
are you suggesting that I must rename the foreign key columns in each of the tables that references the re-used table id's so that the column names are unique throughout the database?