Tables, it is all in the tables

So the first step of this project was to create the main table(s) where the information was going to be stored. Normally I try not to over normalise the layouts of my databases for my own projects as they do not need over engineered but this time I threw caution to the wind.

I have broken everything down into much smaller tables of 2 (Id and text). There are many of these tables which cover, ref positions, location, game types (womens/mens etc) and Head Ref to name but a few. Then I created a main table that will hold the game data, basically a date and the Id's from the other tables of the specific information.

I then put together a simple form that allowed be to enter games into the db using the information pulled from the other tables I had created. I then populated the DB with all my game history, the only bit of information missing was what teams were playing as I wanted to add this later.