] Assume we have the following application that models soccer teams, the games t
ID: 3820964 • Letter: #
Question
] Assume we have the following application that models soccer teams, 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, main stadium, and to which city this team belongs. • Each team has many players, and each player belongs to one team. Each player has a number (unique identifier), name, DoB, start year, and shirt number that he uses. • Teams play matches, in each match there is a host team and a guest team. The match takes place in the stadium 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 goals he scored, whether or not he took yellow card, and whether or not he took 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.
Explanation / Answer
This can be handled at two levels -player and match.
At player level, you store the red card and yellow card detail. Because, this will affect his player status in subsequent matches too.
At match level, you store the subsitution details. Assuming a table, the headers would look like:
row_id | player1| player2|match_id where player 1 is subsituted by player2.
I can probably elaborate more, but I don't have the details like- are you trying to model a DB or a class for a oops program etc.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.