I have a db that is for sports.
In one table (Teams) I could have a column (sport) in the column would be entries:
Now for example I would have the super 12 teams in the table (thats 12 teams)
So my table would look like:
rugby :: Crusaders
rugby :: Highlanders
rugby :: Hurricanes
As you can see rugby would be in the table 12 times.
With Rugby League, Rugby League would be in the table (I think) 14 times.
I can never imagine a point where there would be any more than 20 duplicate entries.
So heres my question:
Should I build a table : Sport
With id and sport columns
Then build another table: Teams
With sportid, team
The Sport table would only contain at the most 20 sports (an incredably small table) and add to the amount of selects I would have to call on (now querying 2 tables) is it worth it to remove the duplicates from the Teams table ??
And how much difference will it make toward stopping my db from becoming corrupt ??
My guess is not to worry about the duplicate entries as there is so few, but I would rather be told by some-one that knows.
Thanks in advance