I need help. Trying to make a Fantasy Football Database

[Jonathan Brown]

If I had hair I would have already pulled it out by now. I don't understand
why but I'm not only having a brain fart but I think it's in a coma as well.

I can't seem to figure out how my table structure and relationships should
look like. This is going to be a single league Fantasy Football database.
I'm sure I need to have a Players table and then a Players Statistics table
for each week of the season. I then need a Teams table that relates to the
players table so I can tell who's on which team. But I need the Players
table to be a kind of "pool" of players where the teams can pick and choose
who they want on their team. So basically not every record in the players
table will related to a team in the teams table, some of them will be
effectively orphaned.

Then I need a Rosters table so I can create a roster for each team for each
week of the season. And then I need a Games table and/or query where I can
compare two rosters together along with the statistics for each of the
players for each roster in order to determine a score and a winner.

I know I'm asking a lot but I can't figure this out. If I can get just the
basic table/relationship structure figured out I'm sure I can take care of
the rest.