hello. i need my worked checked. i have added a picture of the question and also of what i have done. i am not sure if i have the arrows correct. please check for me and guide me if any errors. thank you.

i had to split up the pictures to get a closer view of the words. i hope this helps. the first 2 picture isnthr question and the last two is my attempted response.

in the first picture, the word in the incomplete oval on the far left is "L_name". hopefully therest of the image is more readable now. sadly I cant find the feature "if any" where Chegg allows me to upload a screen shot. or image.

Assume we have the following database that models soccer teams, the games they play, and the players in each team. In the design, we want to capture the following - We have a set of teams, each team has an ID (unique identifier name main stadium, and to which city this team belongs. -Each team has many players, and each player belongs to one team. Each player has a number funique identifier name. Do start year, and shirt number that he uses Teams play matches in each match there is a host team and a guest team the match takes place in the stadium of the host team - For each match we need to keep track of the following: o The date on which the game is played The final result of the match The players participated in the match. For each player, how many goals he scored whether or not he took yellow card and whether or not the took red card o During the match one player may substitute another player. We want to capture the substitution and the time at which it took place - Each match has exactly three referees for each referee we have an unique deinen name Do years of expedient. One referee & the main ceferee and the other two atestant referee Design an ER diagram to capture the above requirements. Make sure cardinalities and relationships are clear Assume we have the following database that models soccer teams, the games the We have a set of teams, each team has an ID (unique identifier), name, main sta Each team has many players, and each player belongs to one team. Each player Teams play matches, in each match there is a host team and a guest team. The For each match we need to keep track of the following: o The date on which the game is played o The final result of the match o The players participated in the match. For each player, how many goals he sco o During the match, one player may substitute another player. We want to capt Each match has exactly three referees. For each referee we have an ID (unique ide are assistant referee. Design an ER diagram to capture the above requirements. Make sure cardinalities play, and the players in each team. In the design, we want to capture the following: um, and to which city this team belongs. as a number (unique identifier), name. DoB, start year, and shirt number that he uses. atch takes place in the stadium of the host team. red, whether or not he took yellow card, and whether or not he took red card. ure this substitution and the time at which it took place. entifier), name, Dob, years of experience. One referee is the main referee and the other two and relationships are clear. ER.png Num_of_Fouls ExperienceTime Home Score Away Score Referee at area Job RD Game Itt F_name During Game Red Cards Game + Score mail.google.com Open with Numu Away Town Home Team Team Player D Experience Time me Referee Dt arena Job Referee_ID F_name DuringGame Red_Cards InGamePlayer > Goals Scored inGamePlayer_10 Num of Fouls Num_of_Fouls Date Home_Score Away_Score Away Home Game HE DuringGame is in takepartin +4 Player Away Towicity Name Team arena Team_10 is in Player JerseyNumber joined Name DatoofBarth