You are hired to create a database for managing the information about a local girl soccer league. This league has more than 20 teams. Each team has a name, base-location, 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 her team. But if she plays for another team later, her jersey number may be different. The league needs to keep track all players, including name, phone, DOB, address, and parent’s 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 her stats (such as playing-minutes, goal made, number of faults, etc.). The coach of team is usually appointed for 2-year term. The league needs to know when a coach is appointed, coach’s 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. a. create an ER model for this database.
b. transform this ER model into a set of tables.