Need ERD and Conversion for these:

The requirements you will find below are not necessarily complete. There may be additional details and things you need to keep track of on your database. Think about your experiences as a student along with what you think a faculty member might be concerned with in order to build an adequate database. Students have a student ID, name, address, one or more phone numbers an email address, and one or more parent names and phone numbers. Courses have a course number (e.g., INFO-1 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") Sections 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 course's subject (e.g., INFO-l) indicates which department (e.g., Informatics) offers it Students live in single or double dorm rooms. Each room has a semester rental fee (for the current semester only). In the case of a double room, the fee is split evenly between the two students. Payments by students for their dorm room should record the amount and the date of the payment. Partial payments are permitted. Faculty are people, too! (And, as such, require names!)