I have 3 tables that are central to a database. A high percentage of the other 100 tables in the database reference these 3 tables. This makes the ER Diagram very messy.
Is there an accepted way of grouping these 3 tables together, in the ER diagram, so I can just draw one connection to this group from each table rather than having 3 connections each time?
I was going to have the 3 tables in one very simple ER diagram then another ER diagram for all the other tables with the first ER diagram referenced as a pseudo table in the centre. Is this a valid approach or is there a better way?