Problem #4 (20 points) The local city youth league needs a database system to help track children that kept on each team and the children that on each teanm the coaches for each team. sign up to play soccer. Data needs to be t will be playing on each team and their parents. Also, data needs to be kept on Entities and attributes required: O number, Team name, and Team colors (one for shorts/socks and one for jersey) PLAYER: Player ID number, Player first name, Player last name, a COACH: Coach ID number, Coach first name, Coach last PARENT: Parent ID number, Parent last name, Parent first name, address (Street, City, State, and ZIP Code). name, and Home phone number, and Home The following relationships must be defined: . Team is related to Player . Team is related to Coach. Player is related to Parent. Connectivities and participations are defined as follows: . A Team may or may not have a Player A Player must have a Team. . A Team may have many Players. A Player has only one Team. . A Team may or may not have a Coach. A Coach must have a Team .A Team may have many Coaches. A Coach has only one Team. A Player must have a Parent. A Parent must have a Player. A Player may have many Parents A Parent may have many Players. am page to draw the Crow's foot ERD (including all attributes, PKs, FKs and with any Use the back of the previous draw the M:N relationships resolved) for the data model described above