Create An ERD. With All The Given Requirements And Any Additional Entities/Relations That Are Necessary.

Students have a student ID, name, address, one or more phone numbers and one or moreemail addresses, and a parent name and phone number.

Courses have a course number (e.g., INFO-I 308), a title (e.g., Information Representation), and a number of credit hours. Courses have sections.

Classrooms have a capacity, and one or more features (e.g., computer lab).

Section of courses are taught by faculty who have a rank, hire date, an office a phone number, one or more email addresses.

Classrooms and offices are types of rooms, which are in buildings that have names and addresses.

Students receive a grade in each section. The system must be able to calculate GPAs and produce letter grades.

A course can be scheduled multiple times each semester in different rooms with different instructors.

Students take sections during semesters that have a title, a start date, and an end date.

Courses may have one or more other courses as prerequisites.

Students pursue one or more majors. Departments offer majors.

Each department has a chairperson who is a faculty member; all faculty members belong to departments.

A courses subject (e.g., INFO-I) indicates which department (e.g., Informatics) offers it.

Students have one or more advisors, who have advisor IDs, names, an office (a room), and one or more areas of expertise.

* Faculty are people, too! (And, as such, require names!)