Problem
A University offers courses which have a course id, course name, number of credits, department offering the course, and a list of prerequisite courses. Each semester, the Department Administrator adds the courses that will be offerred by the department. The courses offerred include a section number, a list of days/times that they meet during each week (for example, Tuesdays, Thursdays from 1 0am-11 :20am), and a professor that will teach the course.
Professors are also added by the Department Administrator, a professor has ID, name, phone number, and office number.
Students have an ID, name, phone, and birth date, can register for courses by selecting available sections from a list of elegible courses.
Draw the Entity Relationship Diagram to be used by your application program, and then transform your diagram into tables in the relational model.