I want to look and er diagram for my topic Each semester, each student must be assigned an advisor who counsels students about degree requirements and helps students register for classes Each student must register for classes with the help of an advisor, but if the student's assigned advisor is not available, then the student may register with any advisor. We want to keep track of students, the assigned advisor for each, and the name of the advisor with whom the student registered for the current term.