So I have inherited an Access database and was tasked with moving the back-end to SQL, which with some help from this community, I was able to do. However, I have come across some table structure which aren't normalized, and am having a hard time getting my hands around how to best restructure these.
So, here is the current structure of the EMPLOYEE table:
EMPLOYEE SUPERVISOR DEPARTMENT
Adam Ant Frank Furter Billing
Bobby Brown Frank Furter Billing
Chris Columbus Gary Gnu Billing
Dom Deluise Garry Gnu Finance
Eddie Edwards Harry Hamlin Sales