Each week there would be a new similar data set, and the outcome from the previous week will be known. I will want to query the data sets to find out whose predictions were the most accurate for each week.
I guess I am struggling with how setup the tables and overall database design. What would be the ideal way to set this up? I guess I really don’t know what should get its own table and what shouldn’t.
Should I keep each season in one giant table that has Week, Predictor, Player Name, Yards Predicted, TDs Predicted, Yards Actual, TDs Actual as the fields?
Have a separate table for NFL Players with columns PlayerID, Player name?
Have a separate table for the predictions of each Week (or maybe Season)?
Have a separate table for each predictor (person who is making the predictions)?
This seems like such a simple thing to think through, but I just can’t seem to decide what makes the most sense on my own. I want to avoid getting the whole thing set up and then realizing I should have done it another way .
my advice is to forget about "the ideal way to set this up" and use a single table
in fact, you can likely do it in a spreadsheet, just like the one you posted on google
what was your reason for not wanting to do it with a spreadsheet?
Well I was planning to accumulate several years of data, but maybe the best thing to do is use a spreadsheet until the year is finished and then put it into the database.
I also want to have people eventually input their picks on a web form that will go into a MySQL database.
For 4 people a spreadsheet would work but I think it would get too big with a lot of people playing.
Thanks a lot for the suggestion though, believe it or not it makes me feel a lot better about not being able to figure out how I should set it up given that it's pretty simple... I am probably making it overcomplicated for no good reason.