E-R diagram for favourite sports team statistics

Q) Design an E-R diagramfor keeping track of the exploits of your favourite sports team. You should store the matches played, the scores in eachmatch, the players in each match and individual player statistics for each match. Summary statistics should be modeled as derived attributes.

Answer :

E-R diagram for favourite team statistics

Q) Extend the E-R diagram of the previous question to track the same information for all teams in a league.

Answer : Note that a player can stay in only one team during a season.

E-R diagram for all teams statistics

Related Topics : E-R diagram for a university