F
fipp
I have a database set up with information pertaining to football games.
I have a player table and as you would assume that information is all about
the individual players. (names etc...)
I have a play table. The play table is information about each play in a
game.(down, distance, time on clock, etc...)
Now I would like to keep track of which player is playing which of the 11
positions on the field on each play. I am not sure weather I should add the
11 positions as fields in the play table? Should I add a new table and link
play and player? If I create a new table should the fields be position and I
type the position in and link the player name or should the fields be pos1,
pos2, etc...?
The last thing that I would like to add to it is on any given play there may
be some stats tied to each player for example a tackle or an assisted tackle.
It is possible in the way we grade for more than 1 person to be credited with
the tackle or assisted tackle on each play.
I have a player table and as you would assume that information is all about
the individual players. (names etc...)
I have a play table. The play table is information about each play in a
game.(down, distance, time on clock, etc...)
Now I would like to keep track of which player is playing which of the 11
positions on the field on each play. I am not sure weather I should add the
11 positions as fields in the play table? Should I add a new table and link
play and player? If I create a new table should the fields be position and I
type the position in and link the player name or should the fields be pos1,
pos2, etc...?
The last thing that I would like to add to it is on any given play there may
be some stats tied to each player for example a tackle or an assisted tackle.
It is possible in the way we grade for more than 1 person to be credited with
the tackle or assisted tackle on each play.