cer. The local city deseri youth league needs a database system to help track children that siga ueam and eeibed Data needs t league below unfa needs to be kept on the coaches for each team. Draw the data Entities required: Team, Player, Coach, and Parent. Attributes required Team: Team ID number, Team name, and Team coler. Player: Player ID number, Player first name, Player last name, and ach ID number, Coach first name, Coach last name, and Coach home phone Parent: Parent ID number, Parent last name, Parent first name, Home phone 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. . Connectivity's and participations are defined as follows .A Player must have a Team. .A Player has only one Team A Coach must have a Team. e A Coach has only one Team. A Team may or may not have a Player 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 Parent must have a Player A Player may have many Parents A Parent may have many Players. Using Word create the schema/shorthand notation/DBDL Example: COURSE (Crs Code, Crs_Description, Crs Credit) C LASS (Class Code, Crs_Code, lass_Section, Class_Time) FK Crs Code Course