Problem #2 (20 points) the local city youth league needs a database System to help track children who sign up to play soccer to keep data on each team, the coaches for each team, the children who will be playing on each team Entities and attributes required: (atniog TEAM: ID, name, and colors (one for shorts/socks and one for jerseysi soldats PLAYER: ID name and date of birth COACH: ID, name, and phone number. PARENT: ID, name, phone number, and address.CDISE D EESEO SE O Connectivities and participations are defined as follows -EECE GIVI A TEAM may or may not have any PLAYERS. A TEAM may have many PLAYERS A PLAYER must be on one and only one TEAM. A TEAM must have a COACH assigned to it. A TEAM may have many COACHes A COACH must have a TEAM A COACH may be assigned to coach many TEAMS. A PLAYER must have one and only one PARENT. A PARENT must have at least one PLAYER. A PARENT may have many PLAYERS. Draw the Crow's foot ERD (including all attributes, PKS, FKs) for the data model described above. Ens relationships are resolved and all attributes are atomic. Use appropriate prefixes for all attributes