Please help me check this microsoft access database task. You are in charge of keeping track of the players, coaches and referees in an amateur

football league. The following design has been given to you, and you need to correct it$!$

Referee $($lastname$,$ firstname, street, city, state, phone, division$)$

Coach $($Division$,$ phone, lastname, firstname$)$

Player $($lastname$,$ firstname, division, coach$)$

Division $($name$,$ referee, coach, area$)$

Correct and create a set of tables for the league in $3$NF$.$ Represent your answer in

DBDL$.($i$.$e$.$ give table name and fields. Underline the primary key.$)$ Draw an entity$-$

relationship diagram. $(10$ pts$.)$

Referee $($RefereeID$,$ lastname, firstname, street, city, state, phone$)$

Coach $($CoachID$,$ lastname, firstname, phone$)$

Player $($PlayerID$,$ lastname, firstname, CoachID, DivisionID$)$

Division $($DivisionID$,$ name, RefereeID, CoachID, area$)$

Identify any assumptions you made that will assist in my understanding of your

solution.

$($Must be included$)$