Answered step by step
Verified Expert Solution
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 ...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