... In designing databases, the initial steps of drawing the entity relationship diagrams play a vital role in ensuring that the database works efficiently. The key components of these diagrams are entities and the relationships that exist among them. It is therefore wise to draw these diagrams before developing the baseball statistics database.
To begin with, we must identify the attributes within the baseball statics. Identified attributes are as follows. Players are labeled as pitchers and hitters. The hitter statics include homeruns, batting average, stolen bases, doubles, triples and walks. The pitcher statistics are strikeouts, walks, saves, innings, pitched, earned runs, wins...