Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You have recently volunteered to help out with accounting and finance at your local volleyball club. The club regularly receives match sales, as well
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.
Step by Step Solution
★★★★★
3.34 Rating (151 Votes )
There are 3 Steps involved in it
Step: 1
Advantages and disadvantages of using spreadsheets as a Database Advantages Disadvantages Quick to s...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started