(Solved) : Question Ea 2 Assume Necessary Data Wherever Required 10 Module 1 1 Assume Following Appli Q42770483 . . .

question from ea 2) Assume necessary data, wherever required. 10 MODULE-1 1. a) Assume we have the following application that

question from ea 2) Assume necessary data, wherever required. 10 MODULE-1 1. a) Assume we have the following application that models soccer teams, 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, Date of Birth, 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: o The date on which the game is played o The final result of the match o 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. o 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 three referees. For each referee we have an ID (unique identifier), name, Date of Birth, years of experience. One referee is the main referee and the other two are assistant referee. Design an ER diagram to capture the above requirements. State any assumptions you have that affects your design. Make sure cardinalities and primary keys are clear. P.T Show transcribed image text question from ea 2) Assume necessary data, wherever required. 10 MODULE-1 1. a) Assume we have the following application that models soccer teams, 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, Date of Birth, 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: o The date on which the game is played o The final result of the match o 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. o 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 three referees. For each referee we have an ID (unique identifier), name, Date of Birth, years of experience. One referee is the main referee and the other two are assistant referee. Design an ER diagram to capture the above requirements. State any assumptions you have that affects your design. Make sure cardinalities and primary keys are clear. P.T

Expert Answer


Answer to question from ea 2) Assume necessary data, wherever required. 10 MODULE-1 1. a) Assume we have the following application…

Leave a Comment

About

We are the best freelance writing portal. Looking for online writing, editing or proofreading jobs? We have plenty of writing assignments to handle.

Quick Links

Browse Solutions

Place Order

About Us