I've got a table, where my "club" has a name. Let's say it's the Los Angeles Swift.
However my project is looking at the club's history. Back in 1924 they were called the Los Angeles Wildcats.
When viewing the results of a particular year. I want to look up the club name as per that year.
My idea is to do a clubName table. Linking to the clubData table. clubData will have clubId which I can index too.
I'll then have start and end dates for the club name. I can search for the name that falls within any start/end dates.
My concern is, how can I avoid any overlap? what happens with the current name which has no end date?
Name changes in this project are common so need to have this catered for.