Draw an ERD in third normal form for the situation described below. Show named entities, relationships with cardinality and optionality, the unique identifier (primary key) attribute(s) for each entity, and any other attributes required to support the situation as described. You do not need to show foreign keys or relationship names.A student must be assigned an advisor who counsels the student about degree requirements. Each quarter, students must register for classes with the help of an advisor, but if their assigned advisor is not available, they may register with any advisor. Create an ERD that keeps track of students, their assigned advisor, and with whom the student registered for the current quarter.