ach semester, each student must be assigned an adviser who counsels stdents about degree requirements and helps students teginter for classes viser, but if the student's assigned adviser is not available, the student may register with any adviser. We must keep track of students, the assigned Represent this situation of students and advisor with an ER diagram with all constraints. State any assumptions that you have made. Convert the ERD into relational model. (5) ssume data value iff it is missingeeded] Once you upload files from your second device click on asun In check our