Question: Question 1. (10 points) Each semester, each student must be assigned an adviser who counsels students about degree requirements and helps students register for classes.
Question 1. (10 points)
Each semester, each student must be assigned an adviser who counsels students about degree requirements and helps students register for classes. Each student must register for classes with the help of an adviser, 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 adviser for each, and the name of the adviser with whom the student registered for the current term. Represent this situation of students and advisers with an ER diagram.
Please give assumptions, entities, associations, cardinalities, and all appropriate keys and super/sub types, if necessary.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
