soccer database

[delboy2405]

Hi,

Newbie to this site, my database knowledge is limited. I've built a few small databases a number of years ago but haven't been near it since. I will be looking to build a database for work at somepoint next year and thought i would hone my skills building a soccer database.



Purpose of database
I am building this database for betting purposes

What I want the database to do:

-Store team results, including scores from mulitple leagues/countries, english and scottish etc
-How many goals scored/conceded for each team, home and away
-Average goals per game, per team, home and away
-How many games do both teams score, per team, home and away
-Display fixtures with stats comparison
-Display results
-Display league table, per league, per country

Not required
-Player Stats
-Stadium Stats
-Weather conditions

Further versions may include:
-When goals are scored per team - first half, second half
-Corners per team, per game, home and away
-Team comparison -Barcelona against Bayern Munich

I have searched the internet for the past week and can not see anything that is similar to what i need. Below is what I have come up with so far:



Tables
Competition Type
League or cup competition

Competition
used to determine between leagues ie, English premiership, scottish championship, what season

Season
What season, 2015 - 2016, 2016-2017

Team
Team names, what country, Arsenal/England

Match
Match taking place, including score

Round
Home win, away win, tie

I'm not sure if what I've got can enable me to start building based on my requirements. Any points would be greatly appreciated.

thanks

[delboy2405]

I've made some updates to the tables. I realised that I can have many competitions to many teams, therefore I've created a joiner table to deal with that many to many relationship.

I've removed Season ID from competition table for the same reason as above, many seasons can have many competitions. Therefore I have creates a CompetitionSeasonJoin

Updated tables below


I'm still not sure on the match and round tables and how I can use them to create league and form tables\queries