I am designing tables for tracking statistics for multiple sports like basketball and football. So my question now is - would it make more sense to
- design a table when both data for basketball and football are stored
- separate the stats for basketball and football completely
- create a base table and store common information there and then split them into 2 different tables where they start to differ from each other
my main concern with option 1 is that down the road, the table might become too complex and too many optional/nullable columns
number 2 might be overkill? i like reusing things whenever i can. number 3 - not sure how this would look like...