Hockey Team Database (Microsoft Access)

I created this database for my hockey team in order to achieve highly detailed analytics. It is designed using Microsoft access, and holds the capacity to use queries to perform a wide range of player and team stat calculations.

The tables are highly integrated and make use of both primary and foreign keys. The Players table contains identifiable player information, the Games table contains both game information and team performance, the Goalie_Stats table contains stats specifically for goalies, and the Player_Stats table contains stats for all other players.

Contents of each table.

Fig. A,B, and C are query examples of fully customized statistical data. Figure A shows how many goals are scored in the first period out of all games played. Figure B shows the average number of saves per game. Figure C shows a cumulative team average of both shots on goal and number of shots allowed.