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 20 teams. Each team has a name, base-location (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 2-year term. The league needs to know when a coach is appointed, coachs contact
number, his/her 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 his/her contact
info. A manger may also work for different teams at different time period. Each team has some helpers/assistants
who are usually parents or volunteers from local communities. The league also needs to keep track their contact
information.
1a 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!