The SnazzVille Table Tennis Club is a professional Table Tennis club. You have been contracted to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Answer rating: 100% (QA)
Solution a The work done during the part ab b b pdV ... View the full answer
Related Book For
Auditing and Assurance Services
ISBN: 978-0077862343
6th edition
Authors: Timothy Louwers, Robert Ramsay, David Sinason, Jerry Straws
Posted Date:
Students also viewed these accounting questions
-
The folowing trial balance of Watervray Co. doss nat balanca. WATERWAY cO. TRIAL BALANCE JUNE 30, 2020 Debit Credit Cash $3.259 Accounts Receivable $2,852 Supplies 1,189 Equipmant 4,189 Accounts...
-
Cash receipts from sales on account have been misappropriated. Which of the following acts would conceal this defalcation and be least likely to be detected by an auditor? a. Understating the sales...
-
A chemist wants to extract copper metal from copper chloride solution. The chemist places 1.50 grams of aluminum foil in a solution of 14 grams of copper (II) chloride. A single replacement reaction...
-
The light bulbs produced by Edison Lighting Corporation last an average of 300 h. The life of the light bulbs is believed to follow a normal distribution with a standard deviation of 10. A customer...
-
"Consider a country whose assets are not held by other countries as official international reserves. If this country has a surplus in its official settlements balance, then the monetary authority of...
-
You can buy a car that is advertised for $24,000 on the following terms: (a) Pay $24,000 and receive a $2,000 rebate from the manufacturer; (b) Pay $500 a month for 4 years for total payments of...
-
Identify the four components of a use case and how they affect each other.
-
In 2014, Pennington Corporation had net sales of $600,000 and cost of goods sold of $360,000. Operating expenses were $153,000, and interest expense was $7,500. The corporations tax rate is 30%. The...
-
A ball of mass 0,5 kg is projected vertically downwards from a height of 1,8 m with an initial velocity of 2 m.s1. The ball hits the ground and bounces two times. The position-time graph for the...
-
Below is the number of hand-washing episodes 20 patients with obsessive-compulsive disorder reported having the previous day. 21, 8, 11, 9, 12, 10, 10, 5, 9, 18, 17, 3, 6, 14, 18, 16, 19, 3, 22, 7...
-
find (a) (f+g)(x), (b) (f-g)(x), (c) (fg)(x), and (d) (f/g)(x). What is the domain of f/g? 7. f(x) = x + 2, g(x) = x - 2 8. f(x) = 2x - 5, g(x) = 2x 9. f(x) = x, g(x) = 4x - 5 10. f(x) = 3x + 1,...
-
Decision making is management"s most important function. Do you agree? Why or why not?
-
Do liquids dissolve structures blocking their path, or do they merely circumnavigate them? Discuss the impact of increased liquidity and gaseousness on hierarchical social structures. Is the current...
-
Why is proper inventory valuation so important? Why does an understated ending inventory understate net income for the period by the same amount? Why does an error in ending inventory affect two...
-
What is Blackstone's theory of environmental rights?
-
External auditors play an important role in ensuring compliance with corporate governance principles through the protection of shareholders' interests. Critically evaluate the role of the external...
-
Why are rules used for scheduling rather than finding the optimal production schedule?
-
Consider model (9.18). What is the effect on the model parameter estimates, their standard errors, and the goodness-of-fit statistics when (a) The times at risk are doubled, but the numbers of deaths...
-
Generally accepted auditing standards require auditors to be independent. Included within this standard are the concepts of independence in fact and independence in appearance. Required: a. Define...
-
When are analytical procedures required, and when are they optional?
-
Which two of the following characterize the work of fraud examiners? a. Analysis of control weaknesses for determination of acceptable fraud risk. b. Analysis of control strengths as a basis for...
-
Give an example of unit technology, mass technology, and process technology. For which type of technology are the prescriptions of the classical organizational theorists best suited?
-
Discuss how interlocking directorates can reduce environmental uncertainty and help manage resource dependence.
-
A few years ago, manufacturers of business jets were soaring thanks to new-found wealth in emerging markets such as Russia. However, in August 2009, Montreal-based Bombardier Inc. announced that it...
Study smarter with the SolutionInn App