Based on the following abbreviated description of Avery University's course scheduling and student advising procedures, prepare an Entity-Relationship (E-R) diagram that reflects the key entities and relationships.
Course Scheduling:
In consultation with the vice-president of Academic Affairs and the Registrar's Office, each academic department chair decides which courses will be offered each semester and how many sections of each course will be scheduled. Courses are scheduled in sections meeting at different times over the course of the week. Some courses are scheduled in multiple sections. The department chair also assigns a faculty member who teaches for his/her department to teach each course-section. Students enroll in courses-sections by submitting their schedule selections to the Registrar's Office. In assigning students to sections, the Registrar gives preference to students based on their class standing (i.e., Senior, Junior, Sophomore, and Freshman).
Student Advising:
Student academic advising is done according to each student's major. Each student chooses a faculty advisor from his/her major department. While each student has only one "official" academic advisor, each faculty person advises several students, up to a maximum of 15 advisees.

Question

Quizplus · Accepted Answer

The Answer of Based on the following abbreviated description of Avery University's course scheduling and student advising procedures, prepare an Entity-Relationship (E-R) diagram that reflects the key entities and relationships.
Course Scheduling:
In consultation with the vice-president of Academic Affairs and the Registrar's Office, each academic department chair decides which courses will be offered each semester and how many sections of each course will be scheduled. Courses are scheduled in sections meeting at different times over the course of the week. Some courses are scheduled in multiple sections. The department chair also assigns a faculty member who teaches for his/her department to teach each course-section. Students enroll in courses-sections by submitting their schedule selections to the Registrar's Office. In assigning students to sections, the Registrar gives preference to students based on their class standing (i.e., Senior, Junior, Sophomore, and Freshman).
Student Advising:
Student academic advising is done according to each student's major. Each student chooses a faculty advisor from his/her major department. While each student has only one "official" academic advisor, each faculty person advises several students, up to a maximum of 15 advisees.

Based on the Following Abbreviated Description of Avery University's Course