Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The SnazzVille Table Tennis Club is a professional Table Tennis club. You have been contracted to draw up a data model to model their

 

The SnazzVille Table Tennis Club is a professional Table Tennis club. You have been contracted to draw up a data model to model their operations. You've managed to identify the following entities: Coach Tournament Match Player Hall What now remains is to formulate the business rules. That is all that is required in this question: formulate the business rules, given the entities above, and the information below. Do not include or create any extra entities, and do not resolve many-to-many relationships to create bridge entities. The info you gathered that can now be used to infer the business rules is as below: The club consists of a number of coaches, assistant coaches and players. The club also currently has six table tennis halls where matches take place, but there are plans to increase the number of halls in future. When a player joins the club, they are immediately assigned to a specific coach who remains their coach for the rest of the duration of their stay at the club. Coaches each take on a number of players, with no known limit. Some take a while to be assigned a player after they are employed. Some coaches may take the role of assistant coach for a number of other coaches over time, depending on the circumstances. Generally, we try to ensure that coaches don't assist more than 5 other coaches, as this would overwork them. One coach may be assisted by a number of other coaches, depending on the circumstances, but not more than 3. Twice a year, the club has an internal tournament between all the players. The tournament hosts a series of matches. Each match is played by no more than, and no less than, two (which is many) players that are playing each other, and takes place in a specific hall, at a specific time and date. Each player may play a number of matches in each tournament, obviously. Each match also has a specific outcome which takes the form of the score that each player had in the game. Once again reminding you NOT to create any extra entities other than the five I've listed at the top of this question. Please note that we will deduct a small [0.5 marks] for every business rule that you list that shouldn't be listed; therefore avoid guessing and listing randomly.

Step by Step Solution

3.46 Rating (162 Votes )

There are 3 Steps involved in it

Step: 1

Solution a The work done during the part ab b b pdV ... 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

Auditing and Assurance Services

Authors: Timothy Louwers, Robert Ramsay, David Sinason, Jerry Straws

6th edition

978-1259197109, 77632281, 77862341, 1259197107, 9780077632281, 978-0077862343

More Books

Students also viewed these Accounting questions

Question

What are the objectives of job evaluation ?

Answered: 1 week ago

Question

Write a note on job design.

Answered: 1 week ago

Question

Compute the derivative of f(x)cos(-4/5x)

Answered: 1 week ago

Question

Discuss the process involved in selection.

Answered: 1 week ago