Draw ER diagrams for the following scenario using MS Visio
Each semester, each student must
be assigned an adviser who counsels students about degree requirements and helps students register for classes. Students must register for classes with the help of an adviser, but if their assigned adviser is not available, they may register with any adviser. We must keep track of students, their assigned adviser, and with whom the student registered for the current term. Represent this situation of students and advisers with an E-R diagram.