You have recently volunteered to help out with accounting and finance at your local volleyball club. The club regularly receives match sales, as well as revenues from other sources, and it has been decided that some of these revenues can be returned to the players of the club. Each player in the volleyball team will therefore receive a small pay-out for playing. The pay-out will be dependent on the player's contribution to a team, the leagues in which the team plays, and how many matches a team plays in every league. You have been tasked to set up a database that carries enough information to allow the calculation of these pay-outs. Another volunteer presents you with the following diagram, which depicts a data model that should help you with setting up the database. Contributes to Plays Matches in Player Team League You decide to implement your database in Excel. You note, however, that the model contains two many-to-many relationships - it cannot be directly implemented into Excel in this way. b) Implement your normalised model in Excel. For each concept, mark the columns that are primary keys and foreign keys. Identify at least one extra column for every concept in the model and add at least three rows of imaginary data for every concept (e.g., imaginary player names, team names etc.). Insert screenshots of each Excel worksheet in your report. Do not include the actual Excel spreadsheet file in the document. The screenshots are sufficient. Please note that you do not have to calculate the player pay-outs in the Excel spreadsheet. The spreadsheet only needs to capture the data to calculate the pay-outs at a later time. Add your candidate number to the Excel worksheets without further identifying yourself. Your candidate number must be visible on the Excel worksheets in all screenshots [20 Marks] You have recently volunteered to help out with accounting and finance at your local volleyball club. The club regularly receives match sales, as well as revenues from other sources, and it has been decided that some of these revenues can be returned to the players of the club. Each player in the volleyball team will therefore receive a small pay-out for playing. The pay-out will be dependent on the player's contribution to a team, the leagues in which the team plays, and how many matches a team plays in every league. You have been tasked to set up a database that carries enough information to allow the calculation of these pay-outs. Another volunteer presents you with the following diagram, which depicts a data model that should help you with setting up the database. Contributes to Plays Matches in Player Team League You decide to implement your database in Excel. You note, however, that the model contains two many-to-many relationships - it cannot be directly implemented into Excel in this way. b) Implement your normalised model in Excel. For each concept, mark the columns that are primary keys and foreign keys. Identify at least one extra column for every concept in the model and add at least three rows of imaginary data for every concept (e.g., imaginary player names, team names etc.). Insert screenshots of each Excel worksheet in your report. Do not include the actual Excel spreadsheet file in the document. The screenshots are sufficient. Please note that you do not have to calculate the player pay-outs in the Excel spreadsheet. The spreadsheet only needs to capture the data to calculate the pay-outs at a later time. Add your candidate number to the Excel worksheets without further identifying yourself. Your candidate number must be visible on the Excel worksheets in all screenshots [20 Marks]
