This E-R diagram example keeps track of the exploits of your favorited sports team. The database design stores the matches played, the scores in each match, the players in each match and individual player statistics for each match. Summary statistics is modeled as derived column with the use of a stereotype.