Please help me with this hw. It's from a database system class. Thanks a lot!

Draw an ER diagram for a university database that keeps track of students and their majors, transcripts, and registration as well as of the university's course offerings. 1. For each Person, the database maintains information on the person's Name, social security number, address, and date of birth. Faculty and Student are two sub-classes of Person. a. Faculty has rank, office, office phone, and salary, and all faculty members are related to the academic department(s) with which they are affiliated. b. Student has class attribute. Each student is also related to his or her major and minor departments, if known, to the course sections he or she is currently attending, and to the courses completed (shown on transcript). Each transcript instance includes the grade the student received in the course section. i. Graduate_Student is a sub-class of Student. For each graduate student, we keep a list of previous degrees. We also relate the graduate students to a faculty advisor and to a thesis committee if one exists. 2. An academic department has the attributes name, telephone, and office number and is related to the faculty member who is its chairperson and to the college to which it belongs to. 3. Each college has attributes college name, office number, and the name of its dean. 4. A course has attributes course number, course name, and course description. Several sections of each course are offered, with each section having the attributes section number and the year and semester in which the section was offered. Section numbers uniquely identify each section. The sections being offered during the current semester are in a sub-class Current_Section of Section. Each section is related to the instructor who taught or is teaching it, if that instructor is in the database