Complex Table Relationships Question

I currently have the following: An employee table (built already)– where each individual gets a row with their demographic info An annual employment snapshot (built already) – where each indivi...