Q1. Draw an E-R Diagram for the following situation At the university system each STUDENT must be assigned an ADVISOR who counsels students about degree requirements and helps students register for classes (COURSE). Each student must register (REGISTRATION) for classes with the help of an advisor, but if the student's assigned advisor is not available, the students may register with any advisor. We must keep track of students, the assigned advisor for each and the name of the advisor with whom the students registered for the current term Tips Attributes of STUDENT include Student_ID (the identifier), Name, and Major. Attributes of ADVISOR include Advisor _ID (the identifier) Name, and Department. Attributes of COURSE include Course_ID (the identifier). Title, and Credits. Attributes of REGISTRATION include Semester, and Year. Based on your background, think of logical and standard relationships between the given entities