You have recently volunteered to help out with accounting and finance at your local volleyball club....

Transcribed Image Text:

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 Plays Matches in to 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. c) Another volunteer suggests that you use database software such as MS Access instead of spreadsheet software. Critically discuss the advantages and disadvantages of using spreadsheet software such as Excel for the purposes of creating a database such as the one you have just created. 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 Plays Matches in to 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. c) Another volunteer suggests that you use database software such as MS Access instead of spreadsheet software. Critically discuss the advantages and disadvantages of using spreadsheet software such as Excel for the purposes of creating a database such as the one you have just created.

Answer rating: 100% (QA)

Advantages and disadvantages of using spreadsheets as a Database Advantages Disadvantages Quick to s... View the full answer