Opinion on design Structure
I have an employee database, in our industry we rehire people all of the time. What would be the best way to capture this.
I have an employee table now where I figured I would have a portal to show past employment, so would I need a past employment table, would I need a table between those.
Lost as to the best way to proceed. Thanks