The following are the requirements for a design of a database for a new premier soccer league in Australia. Representatives of current Australian state soccer clubs have come together to form the new Australian Premier League (APL). They have set up a Management Board to oversee the creation of this new league, and have commissioned you to design the database.
For this first stage, APL are only interested in maintaining data at the club level, to ensure that the clubs are tracking well for future success. Therefore, the APL needs information regarding the running and maintenance of the clubs, including their players and coaches, stadiums, sponsors and sponsor contributions, members, and all saleable merchandise. Any other club financial requirements, including club assets and running inventory are kept on separate financial databases, and are not part of this database project.
All attributes containing metrics will be sourced from club databases and are accumulated values in this database. i.e. player attributes like “number of tackles” etc., will be read from the club database and then added to the current value in this database.