Question: You are hired to create a database for managing the information about a local boy baseball league. This league has more than 2 0 teams.
You are hired to create a database for managing the information about a local boy baseball league. This league
has more than teams. Each team has a name, baselocation township and an email address as the contact. Each
team has a manager and a coach. Each team has multiple players. A player has a jersey number in his team. But if
he plays for another team later, his jersey number may be different. The league needs to keep track all players,
including name, phone, DOB, address, and parents phone. The information about the game is also important to the
league, such as teams played, game time, location and the scores. The league not only wants to know which team
plays games, but also which player played at each game and his stats such as betting statistics, etc. The coach of
team is usually appointed for year term. The league needs to know when a coach is appointed, coachs contact
number, hisher profession, education degree received, etc., A coach may coach different teams at different time
period. The information of manager of each team should be also stored in the database, including hisher contact
info. A manger may also work for different teams at different time period. Each team has some helpersassistants
who are usually parents or volunteers from local communities. The league also needs to keep track their contact
information.
a create an ER model for this database
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
