Ahh, So in this case, technically, addresses table has no need of having referential integrity with clients. Since multiple clients can have the same address. And applying referential integrity would require every new client record to create a new address record. Is that about right?
I'm definitely still trying to grasp some basics here.
I decided to combine some tables that I thought would be more efficient. I combined clients and employees into an individuals table and combined client training and employee training together since the data columns were the same, I figured that I could distinguish the differences between client and employee data using queries rather than separating them into their own tables.
I have been applying referential integrity to everything since I started building this, so now I need to analyze what actually needs it. I did remove the integrity on company to individuals (originally clients) before the snapshot