The board of A-league soccer have decided to modify their initial data base specifications, leading to a number of modifications from the initial model. The new aim of the A-league board is to provide...

The board of A-league soccer have decided to modify their initial data base specifications, leading to a number of modifications from the initial model. The new aim of the A-league board is to provide members and fans access to data about players, clubs and matches, in order to help them with their tipping competitions. You have been provided with the updated solution of the new conceptual data model, including the ER diagram and the data ready to be loaded in. You have been commissioned to continue your role, (in your capacity as a Database Management System consultant), to write the SQL statements to create the database and its tables; import the data; and to provide SQL solutions to a number of queries. The database should be created based on the ER diagram, (found at the end of this document), and with the provided data. The provided sample data is to be used for inserting data into the tables. This data can be found in an accompanying file,”ass2itech1006-2017-INSERT.sql”. You will need to import this file into your database. You will also need to write some insert statements, (please refer to question j, in the “nnnnnnnnquery.sql” file). Further, in this template query file, you will also need to add the results to the rest of the provided queries