Please answer with full steps for better understanding. Instructions:

Review the figure below which contains a simplified ERD for a school database. Map it into

an ER$-$Schema $($text version$)$ using the preferred rules specified in the lectures in order to

reflect the requirements shown and then proceed to answer all the questions posed in this

assignment.

$1-$ How many tables result from efficiently mapping the ERD using the steps and preferred rules discussed in the lectures?

$2-$ select all the fields that the table STUDENT should contain in the final and most efficient mapping of the ERD presented

$3-$ Using the preferred methods explained in the lectures, select all the fields that the table COURSE should contain in the final and most efficient mapping of the ERD presented

$4-$ Using the preferred methods explained in the lectures, select all the fields that the table COURSE$-$OFFERING should contain in the final and most efficient mapping of the ERD presented

$5-$ Using the preferred methods explained in the lectures, select all the fields that the table ENROLLS should contain in the final and most efficient mapping of the ERD presented

$6-$ Using the preferred methods explained in the lectures, select all the fields that the table ADVISOR should contain in the final and most efficient mapping of the ERD presented

$7-$How should the recursive relationship REQUIRES be mapped in the ERD using the preferred methods explained in the lectures $($select ALL options that apply$)$:

$8-$ Using the preferred methods explained in the lectures, which relationship$($s$)$ require the creation of new table$($s$)$ in the most efficient mapping?