There is a local soccer league with 4 teams (Alpha, Bravo, Charley, Delta) Players aged 10-14 can sign up to join the league, later they are assigned to teams. Each team has a head coach, who is assisted by some other adults. Note that assistants may help more than one team. One game can be played per day on the single field that is available, at the park. A schedule will be set up, the two teams that play on a day will be designated "home" who get to wear colourful jerseys (shirts)while the other will be "visitor" and wear white jerseys. After a game is played, each team will have 1 added to its number of wins, losses or ties, depending upon the outcome of the game The attributes for each entity are: Players: name, address, phone, birthdate Teams: name, wins, losses, ties - counts initially 0 Coaches: name, phone, year_joined The E-R diagram follows: Players assigned Teams Coaches assists home visitor visitor_points home points date