Answered step by step
Verified Expert Solution
Link Copied!

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Financial Accounting

Authors: Fred Phillips, Robert Libby, Patricia Libby

5th edition

78025915, 978-1259115400, 1259115402, 978-0078025914

More Books

Students also viewed these Accounting questions

Question

How did the authors avoid the post hoc fallacy?

Answered: 1 week ago