draw an ERD, using Chen notation that models these requirements for a university database. You may add details to your ERD if they seem necessary and dont conflict with the given requirements. State your additional assumptions.

Students have a unique ID.

Courses have multiple sections. Each course has a unique ID. Sections have unique IDs.

Students may take several courses per semester. Students register for one section of the course they want to take. Students attend one section of a course they have registered for in that semester.

Students earn a grade for each section of a course they have attended.

Students remain in the system even if they are not currently enrolled.

Faculty can teach one or more sections per semester.

Both Faculty and Courses belong to one and only one department. Departments and faculty have their unique IDs.

Each faculty can act as an advisor to a student. A student can have at most one advisor but are not required to have one.

This scheduling system should also keep track of Semesters when each section of the course is offered.

Suggest at least 4 additional attributes for each entity and use correct symbols to show them in the diagram.

Check that your design would allow producing student transcripts with course dates, grades, and GPA information.