Q:

Proper Table naming convention for a many-to-many intersect table

I have a many to many relation for: Client and Broker tables (just an example). Obviously, each client can have multiple brokers and each broker can have multiple clients. What is considered the proper naming convention for the intersect table.... is it ClientBroker...?

A:

I would prefer "Clients_Brokers" (pluralizing both names to indicate many-to-many).

A:

I usually use the names of both of the joining tables.
So, in your case, ClientBroker.

A:

I prefer to distinguish between intersect tables and actual transactional tables. 
So, I end them with Map. So it would be Client_Broker_Map, or ClientBrokerMap. 

