Draw an ERD for this situation and place minimum and maximum cardinalities on the diagram. Also, draw a data model for this situation using the tool you have been told to use in your course (Microsoft Visio preferably, but any other tool works). State any assumptions that you have made.

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, the student may register with any advisor. We must keep track of students, the assigned advisor for each, and the name of the advisor whom the student registered for the current term. Represent this situation of students and advisors with an E-R diagram. Also, draw a data model for this situation using the tool you have been told to use in your course.