$($a$)$ You are asked to design a database which will hold data about university students academic advisors, their club memberships, the moderators of the clubs, and the act that the clubs sponsor.

Attributes required:

Student: StuName, Major, Credits

Advisor: AdvisorID, AdvisorName, Dept, Office

Club: ClubName, President, VicePres, MeetingRm, ClubModerator $($an advisor$)$

Activity: ActivityName, Date, Time, Place

Some facts to note:

$-$ Each student is assigned to one advisor but an advisor counsels many students.

$-$ Each student can belong to any number of clubs.

$-$ Each club will have one moderator $($advisor$)$ but an advisor can moderate more one club.

$-$ Clubs can sponsor any number of activities.

$-$ Each activity is sponsored by only one club.

$-$ There may be several activities scheduled for one day.

i$)$ Draw an Entity Relationship Diagram $($ERD$)$ for the above database, statir assumptions that you make. Be sure to identify all relationships, cardinalities an weak entities, if any.

ii$)$ Convert the ERD in $($i$)$ to an equivalent relational schema in third normal form Explain your answer.