2 Replies Latest reply on Nov 26, 2013 10:06 AM by MikeProcopio

    Having trouble with my basketball stat tracking solution

    MikeProcopio

      Title

      Having trouble with my basketball stat tracking solution

      Post

           I'm building a solution trying to track certain stats for my basketball players per game.

           I'm tracking each possession of the game and connecting if a player screens well or not. We have 82 games 

           The stat I am trying to track is screening. Every possession I want to link to a player and track if he screened or not, did we score on that play, etc.

           I'd like to have a report on the game listing all the players on my team and how many screens they attempted and connected on.

           In the players table I'd like a portal listing games and their stats.

           I have a players table, game table, and a possession table. I was setting up the solution like this

            

           <Player::pk_id>--------<Game:fk_playerid>< Game;;pk_gameid>-----------<possesion;;fk_gameid>

            

           Not sure if this ail work the way that I need ti to.

            

            

            

           I have a player's table