17. Write the 10 cardinalities that are appropriate for this ERD 18. Write the business rules reflected in this ERD 19. What two attributes must be contained in the composite entity between STORE and PRODUCT? Use proper terminology in your answer. 20. Describe precisely the composition of the DEPENDENT weak entity's primary key Use proper terminology in your answer. 1. The local city youth league needs a database system to help track children who sign up to play soccer. Data needs to be kept on each team, the children who will play on each team, and their parents. Also, data needs to be kept on the coaches for each team Draw a data model with the entities and attributes described here. Entities required: Team, Player, Coach, and Parent Attributes required: Team: Team ID number, Team name, and Team colors Player: Player ID number, Player first name, Player last name, and Player age Coach: Coach ID number, Coach first name, Coach last name, and Coach home phone number Parent: Parent ID number, Parent last name, Parent first name, Home phone num- ber, and Home address (Street, City, State, and Zip code) 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 Team may or may not have a Coach. A Team may have many Coaches. A Player must have a Parent. A Player may have many Parents. .A Player has only one Team. .A Coach must have a Team. .A Coach has only one Team. . A Parent must have a Player . A Parent may have many Players 17. Write the 10 cardinalities that are appropriate for this ERD 18. Write the business rules reflected in this ERD 19. What two attributes must be contained in the composite entity between STORE and PRODUCT? Use proper terminology in your answer. 20. Describe precisely the composition of the DEPENDENT weak entity's primary key Use proper terminology in your answer. 1. The local city youth league needs a database system to help track children who sign up to play soccer. Data needs to be kept on each team, the children who will play on each team, and their parents. Also, data needs to be kept on the coaches for each team Draw a data model with the entities and attributes described here. Entities required: Team, Player, Coach, and Parent Attributes required: Team: Team ID number, Team name, and Team colors Player: Player ID number, Player first name, Player last name, and Player age Coach: Coach ID number, Coach first name, Coach last name, and Coach home phone number Parent: Parent ID number, Parent last name, Parent first name, Home phone num- ber, and Home address (Street, City, State, and Zip code) 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 Team may or may not have a Coach. A Team may have many Coaches. A Player must have a Parent. A Player may have many Parents. .A Player has only one Team. .A Coach must have a Team. .A Coach has only one Team. . A Parent must have a Player . A Parent may have many Players