Home‎ > ‎B188 6pm‎ > ‎

Holmgren, Jay

My access project will consist of at least three tables. It will be a project that goes into the details of the MLB playoffs that are currently going on. The database could potentially be useful to someone who wishes to bet on any of the games or just to someone who enjoys baseball. The first table will have general information on the teams that are in the postseason. This will include player names, managers, city, year founded etc. The second table will have player stats and will have a relationship with the team page. Stats include postseason experience, hits, runs, walks etc. The third table will have information on the stadiums that the various teams play at, as the dimensions of the stadiums can affect the outcomes of games. Included in this section would be dimensions, weather, capacity etc. I may add more tables if more situational stats are available but that remains to be determined.