First Steps

I had a lot of ideas about how to display the results, how to import in the data and how I would store all the results. I had to make a couple decisions.

1. I'll use Visual Studio 2010 to create an ASP.NET website and SQL Server 2008.
2. I would start with the FIFA 2010 World Cup. The database would be designed to capture teams, scores, games, results, and in future, players, goal scorers, yellow/red cards and substitutions. I will be ignoring (at least for now) some stats such as passes, tackles, and assists.
3. I would import the data using a combination of various football websites (Wikipedia, BBC.co.uk, Soccernet.com, FIFA.com). I know that in the past there is some 'discussion' about facts, so I will be using official FIFA decisions (e.g. in the 1930 World Cup, there is still discussion between official FIFA documentation and independent researchers over who scored certain goals)

Taking this into account, I did a few rough sketches of what I thought the website would look like, and then I designed a rough database, loading it into my SQL database. The result of this is below.



What's next? Importing in some basic data...