Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Answer both ( a ) and ( b ) The following information that models a male rugby squad, the games they play, and the players
Answer both a and b The following information that models a male rugby squad, the games they play, and the players in each team. In the design, we want to capture the following: We have a set of teams, each team has an ID unique identifier name, Home Grounds, and city they are based in Each team has many players, and each player belongs to one team. Each player has a number unique identifier name, start year, and jersey number that he uses. Teams play matches, in each match there is a home team and an away team. The match takes place on the home grounds of the host team. For each match we need to keep track of the following: The date on which the game is played The final result of the match The players participated in the match. For each player, how many trys he scored, whether or not he was awarded a yellow, and whether or not got a red card. During the match, one player may substitute another player. We want to capture this substitution and the time at which it took place. Each match has exactly Four referees. For each referee we have an ID unique identifier name, DoB years of experience. One referee is the main referee and the other two are assistant referees and the last is a Television Match Official TMO a You are required to draw an entity relationship diagram ERD representing the above model. Be sure to list any assumptions you make and show all attributes for each entity b Convert your ERD to a set of relations.
Answer both a and b
The following information that models a male rugby squad, the games they play, and the players in each team. In the design, we want to capture the following:
We have a set of teams, each team has an ID unique identifier name, Home Grounds, and city they are based in
Each team has many players, and each player belongs to one team. Each player has a number unique identifier name, start year, and jersey number that he uses.
Teams play matches, in each match there is a home team and an away team. The match takes place on the home grounds of the host team.
For each match we need to keep track of the following:
The date on which the game is played
The final result of the match
The players participated in the match. For each player, how many trys he scored, whether or not he was awarded a yellow, and whether or not got a red card.
During the match, one player may substitute another player. We want to capture this substitution and the time at which it took place.
Each match has exactly Four referees. For each referee we have an ID unique identifier name, DoB years of experience. One referee is the main referee and the other two are assistant referees and the last is a Television Match Official TMO
a You are required to draw an entity relationship diagram ERD representing the above model. Be sure to list any assumptions you make and show all attributes for each entity
b Convert your ERD to a set of relations.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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